Forum Discussion

TemiT20's avatar
TemiT20
Copper Contributor
May 12, 2020
Solved

Conditional Formatting if date is past And Cell is Blank

Hello,    Am trying to find a formula that works if a date is past today's date and the another cell is blank to highlight the date cell red, until the blank cell is filled. 
excel
Formulas and Functions
Macros and VBA
  • bhushan_z's avatar
    bhushan_z
    May 12, 2020

    TemiT20 

    =IF(AND(a2>TODAY(),b2=""),1,0)

    use this formula in conditional formatting 

  • beccasme's avatar
    beccasme
    Copper Contributor
    Feb 21, 2022
    Thank you for your help. With this and some more research, I was able to figure it out

Resources