Auto Highlight/Find

[TKB]

Hello,

I am working on a Vendor organizational chart. It lists the vendor, location date and time of work to be done. What i need to do is figure out a way to take an entire column, say 'E' for this example. I need to highlight the Cell based on the date until a cell is reached which contains no data or it reaches the end of the sheet. for example (if today is 8/18/11):

8/20/11 would be found and highlighted Green
8/18/11 would be found and highlighted Yellow
8/16/11 would be found and Highlighted Red

The only thing i can think of doing is having the Cell.Select function select each cell until i reach a stopping point, but i would love to take 100's of lines of code and turn it into just a few.

Any ideas?

Thanks for the help!

 

[venkat1926]

use conditional formatting and you can use three conditions of different colors (for versions earlier than 2007)

use add for adding conditions.

see help conditional fomattitng


it will be something llike this

cell value is greater than =today()
and color it as you like (use pattern)
in the third window equal to sigb is necessary

similary equal to =today()

less than =today()