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?