Morning All,
I wonder if I can ask for some guidance on whether there is a way to track say the last 7 days using TODAY within conditional formatting?
I'm looking for something like =A:A=MAX(TODAY()-7)
Needless to say the above isn't working for me. But Not sure what I'm doing wrong? (Assume A:A is the range of data I am looking for the max with) and not any date ranges. Wondering If because I haven't selected any dates to track that's the issues?
Hope this makes sense?
I wonder if I can ask for some guidance on whether there is a way to track say the last 7 days using TODAY within conditional formatting?
I'm looking for something like =A:A=MAX(TODAY()-7)
Needless to say the above isn't working for me. But Not sure what I'm doing wrong? (Assume A:A is the range of data I am looking for the max with) and not any date ranges. Wondering If because I haven't selected any dates to track that's the issues?
Hope this makes sense?