Condition format a row based on a formula

  • Thread starter Thread starter Tysmema
  • Start date Start date
T

Tysmema

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