Conditional Formatting with Dates

[blemley]

Hi, I've searched through the board and haven't found an answer to my question. Forgive me if this is a repeat.

I have an Excel 07 report that contains a date value (date1) in column F and another date value (date2) in column AA. I need to use conditional formatting to highlight rows where Col AA < Col F plus 2 days into the future.

For example, if Col AA = 07/07/10 and Col F = 07/06/10, the the row should be highlighted.

Can anyone shed some light on this?

 

[pgc01]

Hi

Select for ex. row 1 and set the conditional formatting using the formula:

=$AA1<$F1+2

Copy the format to other rows as needed.