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?