Highlight a row if cells meet certain conditions

[hotcomper]

Good evening, new post for me. I am trying to use conditional formatting to highlight a row if certain conditions are met.
3 x options Y, N or NA.

If all 3 are Y, Y, Y I want the row highlight green
If I have Y, Y, NA again I want this green (NA should be read as Y)
If any one shows N the row should be red.

Hope this makes sense.

TIA

 

[Luke M]

If those are the only two options, then

1. Start by highlighting all rows green.
2. Create a CF, with rule like: =COUNTIF($A1:$C1, "N")>0
3. Set CF to apply format of red fill

Done.

 

[bosco_yip]

Another option of Conditional Formatting,

New rule formula : =SUM(0+($A1:$D1="N"))

The other like Luke mentioned

Regards
Bosco

 

[hotcomper]

Many thanks. I used your advice Bosco and that seems to have done the trick