I'm Googled out
I have dates entered manually down the C column and i use the standard highlight rule to color the cells i.e Today. Tomorrow and Yesterday. Now my issue is come Friday in the week i wish to have Mondays date highlighted as Tomorrow so it has excluded the weekend. The standard conditional formatting for when date occurs wont work in this instance and i have tried at least 20 formulas from forums etc.
What am i doing wrong ? or is there a simpler way? I just wish it to not count any weekends and make Friday 1 and and Monday the day after so it will highlight as if it was tomorrow