Forum Discussion

Copper Contributor

Jul 07, 2023

Solved

Conditional format blank cell based on how many days past date in another cell

I need to highlight a cell if it remains blank 1 day past date in another cell. For example: I3 has date of 15 May 23. J3 is blank. If today is past date in I3, and J3 is blank, then J3 turns red. If...

excel

Formulas and Functions

NikolinoDE
Jul 07, 2023
tallonland

=AND($I3<TODAY(), J3="")

Paste into cell J3 as Conditional Formatting.

NikolinoDE

Platinum Contributor

Jul 26, 2023

=IF(AND(TODAY()-B1>3,C1<>""),TRUE,FALSE)

Formula test.xlsx9 KB

conditionalheadache

Copper Contributor

Jul 27, 2023

I think I made the problem more complicated than it needed to be. I changed the minus to a plus in the formula and it seems to be working. Thank you for all your help, though. I couldn't have done it without you!