Hello.

Similar to another thread I created recently (my other thread) I would now like to also highlight all columns that have Friday, Saturday, or Sunday at the top.

In row 1, I have the days of the week. These are worked out by using the dates in row 2 and applying the "=TEXT(B2, dddd)" formula.

So, I've created a conditional formatting rule using the following formula: =A$1=OR(Friday, Saturday, Sunday)

I would expect this to say, if the specified cell is equal to Friday, Saturday, or Sunday then apply the following formatting etc. Unfortunately, this doesn't work. I also tried placing " around the days but it doesn't like that either. Is it because the specified cells have a formula in them so it can't see the day? If so, is there a way to get it to recognise it?

Many thanks.