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?

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

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

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?

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?