Can I use 1 conditional format to affect multiple cells based on values in others?

[Funky Gibbon]

To really simplify my problem lets put in column A YES YES NO YES. In column B Mike Sarah Paul Jane.

Is it possible to use a conditional format on cells B1:B4 to be green if cell A1:A4 = YES? So in the above example Mike, Sarah and jane would be in green text/fill but Paul would stay base colours.

I know I could set a format for each individual B column cell, but I have a very long list. This is just a simple example of what I want to achieve.

Edit:
An alternative would be to have "YES" in C1 then condition format 'If A1 = $C$1 then B1 is green. If A2 =$C$1 then A2 is green, and so on.

[mehmetcik]

The Answer is yes.

Select the range that you want the conditional format to apply.

In your case B1 to B4

Write your formula as if you were only writing it for the first cell in your range so

=IF(A1="Yes",1,0)

Excel will handle the complexities for you.

[Funky Gibbon]

Thank you for the reply and whilst I am grateful for your time, it doesn't really help my problem. Maybe you took my question literally as 'Can I?'
If I changed it to 'How do i ....?' would you be able to explain, in simple terms please.
I'm guessing I select the 'Use a formula to determine which cells'. I've tried setting the formula in cell B1 which works fine but then how do I expand it to cover B1:B4?

[Funky Gibbon]

Thank you very much. This is exactly what I wanted.