cells that have dates

[Denny_Yeoman]

I have a spreadsheet with dates in several columns
I need to know if a date in column H is past the date in column D and if it
is, format the date is column H to color RED

 

[JP]

Let's say you have a date in H1 and you want to check it against the
date in D1.

1. Select H1
2. Go to Format Menu, Conditional Formatting
3. Select "Formula Is" and type =$H$1>$D$1
4. Hit "Format" button, Patterns tab and choose an appropriate color
5. Hit OK twice

Now whenever you enter a date in H1 that is later than the date in D1,
H1 will turn whatever color you specified.


HTH,
JP