Home

Help with Conditional formatting

Aaron Lockett
Contributor

I'm Trying to get the dates in Column H to turn red if the current date has surpassed the required date stated in Column H and no date has been entered in Column I. Once a Date is entered into Column I, Column H should turn back to black.

Capture.JPG

Attached is an example to show the conditional format formulas currently being used.

1 Reply

Hi Aaron,

 

You may modify you "red" rule formula as

=(H1-TODAY()<1)*ISBLANK(I1)

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies