conditional formatting
Youneeed to compare two serialdates with each other like below. DateValue()
will convert you string date "11/1/08" to a serialdate.
=TODAY()A1
or
=DateValue("11/1/08")A1
"nativeutah" wrote:
I am having trouble with the conditional formatting, I need to have the
review dates highlighted, if they are past due, I want to use the date of
11/1/08. do I need to have the whole column formated for dates then use
conditional formatting?
example
column a review date
employee name 12/1/08
employee name 6/1/08
|