How can I change column backgrounds to some color (let's say Yellow) for all columns in range G2:AQ32 if the value of G2:AQ2 is either "Sat" or "Sun"?
Basically, I have a calendar in this range and I need to shade the weekends.
How can I change column backgrounds to some color (let's say Yellow) for all columns in range G2:AQ32 if the value of G2:AQ2 is either "Sat" or "Sun"?
Basically, I have a calendar in this range and I need to shade the weekends.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks