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