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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Condition format a row based on a formula 2
Comparison of columns using Conditional Formatting 3
Excel VBA 1
Conditional formatting dates in 2007 5
Formula for Dates and CF Colour then convert to Text 3
Conditional Format Based on Date 3
Conditional formatting dates? 8
formatting excel date list 5

Back
Top