Condition format a row based on a formula

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?
 
B

Bernie Deitrick

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
Formula for Dates and CF Colour then convert to Text 3
Conditional Format Based on Date 3
Help needed 0
Excel VBA 1
Conditional format refers to two cells 1
Conditional Formatting 4th Condition 3
Excel Need Countifs Formula Help 0

Top