Help with conditional Formatting

[Evie76]

Hi, I'm trying to find a way to highlight a cell by using conditional formatting but need help.

I'm trying to highlight cell V4 if there is a Y in cells D4:U4, can anyone explain how I go about achieving this?

Many thanks

Evie

 

[Fluff]

You can use a formula

=countifs(d4:U4,"Y")

 

[Evie76]

You can use a formula

=countifs(d4:U4,"Y")

OMG thank you so much works like a charm

 

[Fluff]

You're welcome & thanks for the feedback.