//flex table opened by JP
PDA

Click to See Complete Forum and Search --> : looking for a function in MS Excel

deltaf508
07-22-2001, 04:10 PM
For all that are pro's at Excel, I am looking for a function that can look at a page of values and highlight various ranges in various colors while you are working on the page (not by graphing it, I already know that is possible).

For example:
100 - 200 = red
201 - 300 = Blue
Etc, etc....

Like I said while you are working on the page so It will show up instantaniously (sp?). Is this even possible.

Any help is appreciated.

Gary
DVNT1
07-22-2001, 04:33 PM
That sounds like the Conditional formating within Excel. I think it is only available since the 2000 version.
deltaf508
07-22-2001, 07:48 PM
You Rock http://www.sysopt.com/forum/smile.gif

Thanks sooooooo much, that is exactly what I was looking for.....

http://www.sysopt.com/forum/smile.gif

Gary