Ok. So I have my document which has the dates on the top row (H5:AI5). I have already conditional formatted it so it will highlight the weekends.
Now the problem, further down in my document (H35:AI35, H65:AI95, H65:AI95,...), I want it to show the dates too. So what I have done is equal them to the top row, e.g. in H35, I formatted it as =H5. However, it doesn't apply the conditional formatting. Is there a fast way that I can equal the conditional format together as well?
I hope there's an easier way coz I'm lazy to apply this conditional format to every row which shows the dates (it's a lot).
Hope you can help asap. Thanks!
Bookmarks