Condition format a row based on a formula

[Tysmema]

I need to conditional format any row in red based on if the date in one cell
is less than 60 days from the date in another cell. What is the formula I
use?

 

[Max]

I need to conditional format any row in red based on if the date in one cell
is less than 60 days from the date in another cell. What is the formula I
use?

Assume start/earlier dates in A1 down, end/later dates in B1 down
Select entire sheet, then apply CF using formula is:
=AND(COUNT($A1:$B1),$B1-$A1<60)
Format to taste > OK out

---

 

[Cimjet]

Hi Tysmema
Select the row you like to change colour and >Conditional Format formula is
:eg: =$A$1<$B$1-60
change cell reference to your need.
Regards
Cimjet