Hello,

What i'm trying to do is conditional format certain columns based on whether
they have "Sat" or "Sun" at the top.

I have the following:

Row 4 Starting at column B Consists of:
Thur Fri Sat Sun Mon etc etc for January (Thursday being the first of the
month and so on)

I then have the same for all the other months, each starting on the first,
with the respective day above it. For example February starts on (B13) the
1st which means that the day would be Sun.

What i'm trying to do is have the columns for Sat & Sun for each particular
month format to grey. Each formatted column will consist of 8 rows.
(Formatting the whole column for 8 rows isn't the problem, it's getting it to
apply only to "Sat" & "Sun")

I have tried the following formula

=B$4="Sat" - which is fine for the first month and formats the whole "Sat"
column, however when applied to the whole sheet it colours straight down
meaning that even though "Sat" is coloured in January, "Tue" will be
formatted in February and March and "Fri" is formatted in April.

I have tried a couple of other forumlas with varying results, but they all
end up formatting the wrong columns.

Any help would be most appreciated.