Conditional format formula
 

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?

Conditional format formula
 

=value(cell)<=today()+30

"ron b" wrote:

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?

Conditional format formula
 

=A2<=TODAY()-30
for equal to or less tha 30 days or
=A2<TODAY()-30
less tha 30 days,
Regards,
Alan.
"ron b" wrote in message
...
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?

Conditional format formula
 

Huh! I'd say "today()+30"

"Alan" wrote:

=A2<=TODAY()-30
for equal to or less tha 30 days or
=A2<TODAY()-30
less tha 30 days,
Regards,
Alan.
"ron b" wrote in message
...
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?

Conditional format formula
 

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.

"FiluDlidu" wrote:

=value(cell)<=today()+30

"ron b" wrote:

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?