Solved Excel: If Date is within 30 days format cells

January 17, 2012 at 22:06:54
Specs: Windows 7
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)


See More: Excel: If Date is within 30 days format cells

Report •


#1
January 18, 2012 at 01:46:53
How you want to format? what is "=/"?

Report •

#2
January 18, 2012 at 07:12:48
✔ Best Answer
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.


Report •

#3
January 18, 2012 at 20:41:06
DerbyDad03,

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


Report •

Related Solutions


Ask Question