Conditional Format Weekends

[S.H.A.D.O.]

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.
SHADO

 

[Domenic]

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)

4) Choose your formatting

5) Click Ok twice

Hope this helps!

 

[Peter_SSs]

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

 

[S.H.A.D.O.]

That works a treat, thanks very much Domenic.

All the Best.
SHADO

 

[Domenic]

That works a treat, thanks very much Domenic.

All the Best.
SHADO

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!

 

[S.H.A.D.O.]

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.
SHADO