Notifications
Clear all
General Excel Questions & Answers
4
Posts
3
Users
0
Reactions
232
Views
Topic starter
I have a cell (I5) that I want to have highlighted red if it is blank and is also 5 days after the date in cell I6. For example, if I5 is blank, and the date in I6 is 10/21/24, I5 should be highlighted red. If I5 is blank and I6 is 10/26/24, I5 would not be highlighted because it is not past 5 days from the date in I6. I have done many (MANY) searches to try to figure this out, but I feel like I am going in circles. I am sure it is something VERY easy, but my tired brain just isn't finding it. Thanks in advance for any advice!
Posted : 31/10/2024 8:17 pm
I believe this CF formula works for you, applied to I5:
=AND(ISBLANK($I$5),$I$6+5<TODAY())
Posted : 01/11/2024 5:00 am
Try this
Use a formula in conditional formatting, the formula:
=AND($I$5="",$I$6<TODAY()-5)
and applies to:
$I$5
Posted : 01/11/2024 5:00 am
Posted : 01/11/2024 6:11 am
