Question about conditional formatting

[KevinLZR]

I have an excel file with some sort of planning.
I can't find some sort of idea on google or this forum if this is possible, so here is my question.

The planning is for every month, and every month has 4 rows (see added screenshot).
Row 1: Weekday names (in Dutch)
Row 2: Weekday numbers (in dutch
Row 3: planning
Row 4: Misc.

What I would like, is when a weekend day has been found, then highlight the 4 rows together with some color (like the screenshot).
So if za or zo, then B2:C5 would be blue.

Is this possible with conditional formatting?

 

[fadee2]

Hi KevinLZR,

Select your data rows, not the day names, and click conditional formatting,

.

Steps to follow for ZA...
Under New Rule, select "Use a formula to determine which cells to format".
In edit rule, type =A$1="ZA", and then click Format, and select color.

Then, steps to follow for ZO...
Under New Rule, select "Use a formula to determine which cells to format".
In edit rule, type =A$1="ZO", and then click Format, and select color.

Create two formatting rules, like this

 

[KevinLZR]

Thanks for your reply!
If I do it like yours then nothing happens.

I select cells A3 to AE5
Then conditional format and use
=A$1="zo"

Nothing is changed.

When I change A$1 to C$2 (C2 = zo) then I get it like the screenshot.

Any ideas what I am doing wrong?

 

[fadee2]

Since your days a placed in 2nd row, try using A$2, instead...

=A$1="zo"

Nothing is changed.

This is because the formula is unable to find "zo" in A$1, thus nothing happens.

 

[KevinLZR]

Since your days a placed in 2nd row, try using A$2, instead...

This is because the formula is unable to find "zo" in A$1, thus nothing happens.

You are absolutely right, this must be A$2. It works now!

Thank for the help!

 

[Fluff]

Rather than having two rules you could use one like

=OR(A$2="zo",A$2="za")

or another way

=LEFT(A$2)="z"

 

[fadee2]

You are welcome..

 

[fadee2]

Rather than having two rules you could use one like

=OR(A$2="zo",A$2="za")

or another way

=LEFT(A$2)="z"

 

[KevinLZR]

Rather than having two rules you could use one like

=OR(A$2="zo",A$2="za")

or another way

=LEFT(A$2)="z"

His also work well indeed!
Less rules to make.

Thanks!

 

[Fluff]

Glad to help & thanks for the feedback.