Checking if many cells have same text value and changing another cell 1

[bleugh]

I have 3 cells (F15, G15 and H15) that display the text "OK" and change to green when some other cells meet a particular requirement, and " " when they dont (easily changeable though)

what I cant do is;

I want another cell to change to green and/or display text when the 3 cells have OK in them,


I've tried nested IF's, etc and searching, I cant find any way of changing a cell based on text values of multiple cells

 

[spinningman]

=IF(F6="ok",IF(G6="ok",IF(H6="ok","all three are OK",0)))

then add conditional formatting to the cell so it turns green if the cell does not equal zero

 

[bleugh]

thanks,

I was missing the "" for the text

1 star for you