cells that have dates
 

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

cells that have dates
 

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

On Nov 14, 4:36 pm, Denny_Yeoman
wrote:
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