Hello Forum,
I have a problem formatting a table which is a monthly activity tracking.
I have a line for each day and I would like all lines related to saturdays and sundays to be highlighted in different color.
I have created 2 rules in the conditional formating menu
Rule 1 : =B6="saturday"
Rule 2 : = B6="sunday"
But for some reason the rule doesnt apply on all the row but just the cells in B column.
Any one with the solution?
Attached is my file for reference.
Thanks in advance
Best
GM
Bookmarks