Hi All,
The formulas below are working perfect for conditional formatting
Format is Yellow if the date is Today =$B2=TODAY()
Format is Green if the date is Tomorrow =$B2=TODAY()+1
Here I want to skip the weekend 2 days if happening before working day. And I want the same green format as for tomorrow.
e.g. If today is last day of week, then I want the upcoming working day cell format green same as for tomorrow.
Bookmarks