Hi. Ok, i'm trying to conditional format a column to RAG rate when i'm approaching deadlines for a specific date. The dates i want my formula to look at are already in my table, but i don't know how to write the formula.
Here's what i want column I to say -
If today is greater than or equal to the date in F2 and is less than or equal to the date in H2, turn green.
If today is equal to H2+1 but less than or equal to I2, turn amber.
If today is greater than I2, turn red.
God I hope that makes sense to somebody.
Thanks in advance!
Bookmarks