Condition format a row based on a formula
 

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?

Condition format a row based on a formula
 

"Tysmema" wrote:
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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Condition format a row based on a formula
 

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
"Tysmema" wrote in message
...
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?