Forum Discussion

adavis726's avatar
adavis726
Copper Contributor
Jul 03, 2019

Conditional Formatting - Based on Cell Value in another column

Hello everyone, I am working on a spreadsheet that has a date in column A. I would like Column B to highlight red in the case that the date in the corresponding cell in column A is due in the next 3...
excel
Formulas and Functions
Twifoo's avatar
Twifoo
Silver Contributor
Jul 03, 2019
Highlight column B and try this custom conditional formatting formula:
=A1-TODAY()<=30
adavis726's avatar
adavis726
Copper Contributor
Jul 03, 2019

Twifoo That seems to have turned the whole B column red.

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jul 03, 2019

    adavis726 

    =($A1-TODAY()<=30)*($A1>1)

    to exclude blank cells in column A