Hello, I would like to Conditional Format a column containing Dates,
Example:
If cell C1 = "Open" then if date in cell A1 = today before or equal to 1PM, then highlight cell C1.
then if cell C1 = "Open" then if date in cell A1 = today after 1PM today and less than 1pm Tomorrow highlight Cell C1
Hope it makes sense.
Basically I need any cell that show "Open" up to 1pm today to be highlighted, and soon after 1PM when the cell changes to "Closed" I need the cells that Show "Open" and past 1PM today till 1PM next day to be highlighted
This is the current Formula i have in the conditional Format But its not working
IF(C1="Open",AND(A1>TODAY()+0.5417,A1<TODAY()+1+0.5417),FALSE)
Thank you all for your Help
OP
Bookmarks