Conditional Formatting


I've tried out the conditional formatting and am unable to show different colored backgrounds for different future date conditions.

As an example: I want to show the date cell to show green if it is a future date with a Green Background UNLESS it is within 90 Days of Today's date. If that is the case, I want to show the background as Yellow.

Any suggestions?

Best Answer


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    You should be able to specify it being in the next 90 days within the conditional formatting rule.

  • Bert Hoffbeck
    Bert Hoffbeck ✭✭✭✭

    Your suggestion worked, thanks.

    But I failed to mention that I also want to format the cell if it is blank.

    I've tried the "is blank" criteria selection, but it doesn't seem to do anything, the cell is left unformatted.

    The formula in the column that I am trying to format is:

    =IF(ISBLANK([Automatic Descent]@row), "", DATE(YEAR([Automatic Descent]@row) + 1, MONTH([Automatic Descent]@row), DAY([Automatic Descent]@row)))

    I'm wondering if the "" portion of my formula is not read as "is blank" and that is why it is not formatting?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!