conditional formating using cells containing dates
 

This worked PERFECTLY for me. Thank you so much. I have one extra question...
Is it possible to make this work so that the condition chosen includes the
day of AND the day after.....
For example:
A1 = Due Date
A2 = Complettion Date (this date could be equal to or greater then the due
date)
Can the formula include this so that it doesn't have to be either/or?

"Biff" wrote:

Hi!

Select cells A1 and A2.
FormatConditional Formatting
Formula is: =AND(A$1=TODAY(),A$2="")
Select your desired style for the first condition.
Click the ADD button.
Condition 2
Formula is: =A$2A$1
Select your desired stye for condition 2.
OK out

Biff

-----Original Message-----
I want to have missed due dates automatically highlighted
using conditional
fromating. Example:
A1 is due date, dd/mm/yy
A2 is completion date, dd/mm/yy
If A2 does not contain a value on the A1 date, I want the
A1 date to turn a
color.
When the A2 date is entered, and the value is later than
the A1 date, I want
both A! and A2 to be a specific color.

Any help would be appreciated.
.