Home/ Questions/Q 6886
Next
Answered
computing
  • 6
Asked: 2021-11-22T00:39:30+00:00 In:

Solved Excel: If Date is Within 30 Days Format Cells

  • 6

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)

Share

    1 Answer

    1. 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.

      • 0