I would like to format excel cells with conditional formatting It is a column of dates and I'd like to determine the following

If the date in the column is less than today +30 days

Is the formula i'm trying to make, but it does not work =/ Any assistance would be greatly apprecited.

if = (today() < +30)

How you want to format? what is "=/"?

Select the cell that wish to Conditionally Format, e.g. A1. Try this formula:

=A1<TODAY()+30

If you need to CF a range, select the entire range and use the first cell in the range in your formula. The CF will be applied to each cell individually.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

DerbyDad03, Thank you muchly. Worked like a champ when I swapped out the A1 for the range of sells I wanted formatted.

Ask Your Question

Weekly Poll