Hi, I'm trying to conditionally format rows in a spreadsheet so that I can determine which rows contain information that needs to be followed up on.
I'm using this formula in the conditional formatting section
=AND(C2=TODAY()+1,D2="C",J2="")
What I need to happen is that anything older than 24 hrs, where D2 is selected as C and where field J2 is left blank should turn yellow to indicate follow up work.
D2 and J2 are drop down validation lists.
it's not working though, and I don't know why.
Thanks for your help
Bookmarks