Turning a row color to "yellow" if one date field is greater than another.

R

Ray Stevens

I would like to automatically turn a row color to yellow if the current date
is greater than a "needed by" date column. What is the best way to do this?
 
G

Guest

Hi

Select the rows necessary and then go to Format/Conditional Formatting. If
your 'needed by' date is in column D use 'Formula Is' and then in the box
type:
=$D1=today()

Hope this helps.
Andy.
 
G

Guest

Sorry - that's if column D equals today.
Try this:
=today()>$D1
Don't forget to set a pattern fill too!

Andy.
 
Top