# Conditional Format Weekends

#### S.H.A.D.O.

##### Well-known Member
Hi everyone,

I have a range of cells B5:G250.
In B I have the date.
In C I have the Day ( i.e. Monday )
In D I have a start time.
In E I have a finish time.
In F I have a total hours worked.
Everything is fine.

I would like to conditionally format cells B:F where C = Saturday OR Sunday please.
Any help will be greatly appreciated.

All the Best.

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Try the following...

1) Select B5:B250, making sure that B5 is the active cell

2) Format > Conditional Formatting > Formula Is

3) Enter the following formula:

=OR(WEEKDAY(\$C5)=1,WEEKDAY(\$C5)=7)

5) Click Ok twice

Hope this helps!

An alternative at step 3 of Domenic's suggestion is this formula:
=WEEDAY(\$C5,2)>5

That works a treat, thanks very much Domenic.

All the Best.

That works a treat, thanks very much Domenic.

All the Best.

You're very welcome! Also, if Column C can contain blanks, you may want to try the following instead...

=AND(\$C5<>"",WEEKDAY(\$C5,2)>5)

Hope this helps!

Hi Domenic,

You're very welcome! Also, if Column C can contain blanks, you may want to try the following instead...

=AND(\$C5<>"",WEEKDAY(\$C5,2)>5)

Hope this helps!
It could do, and that amended Formula is exactly what I was after.

Have a Great Weekend.
All the Best.

Replies
4
Views
304
Replies
5
Views
235
Replies
24
Views
424
Replies
12
Views
617
Replies
3
Views
203

1,221,498
Messages
6,160,160
Members
451,626
Latest member
dcobe

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back