cells that have dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top