# Thread: Conditional Formatting for weekends (2003 SP2)

1. ## Conditional Formatting for weekends (2003 SP2)

Morning all

The screenshot below shows how I have part of a calendar set up, I would like to us conditional formatting to shade the days that are Sat or Sun, I have tried various =IF for day and workday etc. but can't seem to get it.

Cheers

Steve

2. ## Re: Conditional Formatting for weekends (2003 SP2)

If the cells with the days contain text, then use the FormulaIs option with this formula:

=OR(A1="Sat",A1="Sun")

(assumed A1 is currently selected, adjust if not)

If the cells contain a date formatted to show just the day:

=OR(WEEKDAY(A1)=1,WEEKDAY(A1)=7)

3. ## Re: Conditional Formatting for weekends (2003 SP2)

Thanks Jan

I could not get that to make anything change but 'bumbling' around as I normally do I tried =WEEKDAY(D5,3)>4 which seems to work at the moment

Cheers

4. ## Re: Conditional Formatting for weekends (2003 SP2)

Methinks I spoke to soon!!

If you have a moment could you take a look at the example I have knocked up which shows D2:AH2 with the Conditional formating that I have described, if however I now copy this into D3 Conditional Formatting and drag it across to AH3 it works OK but if I then drag the whole row down all cells from D4:AH4 take on the orange formatting?

Cheers

Steve

In my family we have a saying: he who laughs last didn't get the joke in the first place!!

5. ## Re: Conditional Formatting for weekends (2003 SP2)

Select D2:AH6.
Select Format | Conditional Formatting...
Set the formula to =WEEKDAY(D\$2,3)>4
Click OK.
The \$ before 2 means that conditional formatting will look at the cell in row 2.

Next, select D8:AH12.
Select Format | Conditional Formatting...
Set the formula to =WEEKDAY(D\$8,3)>4
Click OK.

etc.

6. ## Re: Conditional Formatting for weekends (2003 SP2)

Fantastic

Thanks Hans

Cheers

Steve

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•