How to remove weekends on conditional formatting

[PillowSam]

Good day everyone,

In the photo below I have made this. Can you help me to not highlight the weekends with the format for plan and actual. and have its separate format. Hope someone can help me on this.

 

[James006]

Hi,
You can test following formula to identify Week-Ends

=WEEKDAY(A1,2)>=6

 

[PillowSam]

Hi,
You can test following formula to identify Week-Ends

=WEEKDAY(A1,2)>=6

Sorry, I think my query was not clear enough. I have been struggling with my first condition which is:
=AND(J$4>=$C5,J$4<=$E5)

because I need that Saturday and Sunday shouldn't be highlighted the same with the plan and actual.

 

[James006]

With the first rule you already have in place...

Have you tried to check the box : Stop if True

 

[PillowSam]

With the first rule you already have in place...

Have you tried to check the box : Stop if True

Well, I haven't. Thank you for answering!

 

[James006]

Glad you could fix your problem