I have an excel sheet in which I wish to use conditional formatting . I would like to change a cell red 30 days prior to the date entered in the cell. I would like to use conditional formatting for all the cells in the column.

Can someone give me the correct formula?

This works for all dates, 30 days or less.

cell Value Is>less than or equal to>=Today()+30

To make this highlight just one day, change the 'less than or equal to' to 'equal to'.

HTH

Art

Close. However, if you want it to appear with a color within that 30 day period, assume cell B2 is the target cell, then in the Conditional Formatting box, on left select "Formula is" in the dropdown. Then on the right, put this formula:

=B2<=TODAY()+30

If you want all of column B to be colored red, when cell B2 is highlighted, then select that column and use this formula:

=B$2<=TODAY()+30

Or adjust according to your own needs.

Thank you, that was very helpful, and solved the problem.