Question asked by user @ Excel forum:-
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 won’t 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 Monday the day after so it will highlight as if it was tomorrow.
To resolve this problem, Our Expert has used the combinations of formulas:- “TODAY”, “WORKDAY” and “IF” functions.
“TODAY” function will help to return the today date.
“IF” function will help to check the condition and then will perform accordingly.
“WORKDAY” function will help to return the serial number of the date before or after a specified number of workdays.
To highlight the tomorrow date we will use the combination of formula in conditional formatting option, follow below given steps:-
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.