Conditional Formatting Issue

[ShoaibAli]

Dear Experts,

Is there any way to highlight entire columns which have specific words such as "Sat", "Sun".

i am using Excel 2016 and have done this via conditional formatting but its not working please help in this regards,

look at below pictures i have tried but not working.

 

[Nuclearman83]

Select the area that you want to highlight A1:AB40 or however long your calendar is. Then select the conditional formatting base on new rule:

=A$2="Sat"

 

[ShoaibAli]

Still not working

 

[Nuclearman83]

This is I did.

 

[Nuclearman83]

Sorry, I can't seem to type today.

 

[ShoaibAli]

Yeah thanks i got it. But i am using =Weekday(C1) formula to get weekday thats why it is not applying

Is there any way to do that

 

[Nuclearman83]

This maybe completely wrong but I always fill out my trackers but using Mon, Tues, Wed then using the "Fill Handle", the little black box in the corner when you select Mon, Tues, Wed all together when you drag it across the screen. Excel will automatically fill everything in. Works for the dates too.

 

[Fluff]

Depends on your system, but try
=OR(C$2=1,C$2=7)

 

[Nuclearman83]

Fluffs answer works way better, thank you Fluff.

 

[ShoaibAli]

Fluff

Thank you so much you did it.