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 

bhushan_z's avatar
bhushan_z
Iron Contributor
May 12, 2020

TemiT20 

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

use this formula in conditional formatting 

CGarb's avatar
CGarb
Copper Contributor
Jul 07, 2022
Thank you for this formula! Works great. I have a question, what do I add go the formula so it only highlights blank cells based off whether or not the other cell has a date in it. The blank cells highlight wether or not there is data in the cells it is going off of. I want to make it so that once the information in the other cell gets added, only then does it calculate this info. For example when I send and invoice to a client, i add the date, once the pay i mark the date paid in a different column but i want to highlight when and invoice hasnt been paid yet.

Resources