Conditional Format multiple rows with colour

Good morning all

I'm trying to get a conditional format to work on a column for multiple rows.

Basically if all the rows say Closed a column will highlight green with the word passed. If one of the rows has the word open in it the column will go amber and have the word fail.

Is this possible at all?

I have tried to attached an example.

Thanks in advance

By "If one of the rows has the word open" you really mean "if AT LEAST one of the rows has the word open" ?

in C19
=IF(COUNTIF(C2:C16,"Closed")=15,"Passed","Failed")

Select C2:C16

Conditional Formatting
New Rule
Use a formula to determine...

2 colours required so 2 formulas needed

=C$19="Passed"
format as green

=C$19="Failed"
format as amber

Did you try the Conditional Formatting instructions as suggested?
Just follow the instructions as given.

You want the column highlighted from C2:C16, either green or amber, yes?
"if all the rows say Closed a column will highlight green"
The Conditional Formatting formula to turn the column green/amber are in the instructions above.

So what do you want to green/amber?

JUST C19 or the C2:C16 range?

Because you said "a column will highlight green".
C19 is a cell. If you just want that cell to highlight green then you should say "cell" not "column"

If you just want C19 to change green/amber then just select C19 in my instructions, not C2:C16

Thats not what I said, is it.

You've selected "Format cells that only contain"
I said use the option "Use a formula to determine..." which is at the bottom of that list.

Do that and it will work.

Or change your exsiting method so it reads

Cell value equal to Failed

Same for the other formula only change it to Passed