Conditional Formatting of rows on a calendar

[Ricardo]

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.

 

[JBeaucaire]

Well, the simplest method is to use conditional formatting on the values in
the cells themselves. One would hope each cell in question has a date value
in it that you are formatting to display however you see fit, even if it's
only to show the day. But the date value needs to be in each of the cells.

If it is, use a conditional format on the whole calendar. Let's assume you
highlighted the whole data set and the key cell selected is G8, then this
would be the conditional format:

Condition1: Formula Is:
=OR(WEEKDAY(G8)=1,WEEKDAY(G8)=7)
....format the pattern background as grey.

Does this help?