Conditional format formula

R

ron b

I would like all cells in a column to turn red 30 days prior to the date
entered in the cell. Does anyone have the required formula to accomplish this?
 
A

Alan

=A2<=TODAY()-30
for equal to or less tha 30 days or
=A2<TODAY()-30
less tha 30 days,
Regards,
Alan.
 
R

ron b

Thank you the formula worked for one cell. How do I make it apply to all
cells in the column? I clicked on the button at the end of the formula box
and dragged the dotted lines to the end of the column, but it did not seem to
work.
 
Top