Condition format a row based on a formula
 

I need to background fill a row in red if the date in one cell is less than
60 days than a date in another cell. What will this formula look like?

Condition format a row based on a formula
 

Select the row, then use a formula like

=$A2<($C2-60)
or
=($A2+60)$C2

(Not sure what "less than 60 days than" means). The key is to use absolute values on the column so
that when evaluated, the formula always refers to the correct columns for every cell within the row.

HTH,
Bernie
MS Excel MVP


"Tysmema" wrote in message
...
I need to background fill a row in red if the date in one cell is less than
60 days than a date in another cell. What will this formula look like?