should I use and IF statment or conditional formatting?

[bionicle]

Good morning all,

having a mental block today so would be grateful for some direction please.


basically I'm at a loss on how to do this simple thing.

Column K, K20:K173 is where I input data and I'm looking to add a formula in cell K11 that returns a the word "yes" based on the said columns data if "RC" is input anywhere in column K.

Column K is filled in green which needs to stay however I need the cell K11 to be a different colour (lets say red).

what's your thoughts?

Any help would be appreciated.

Steve

 

[storm8]

=if(countifs(k20:k173,"rc")>0,"yes","")

 

[bionicle]

Thank you storm8,

worked perfectly, much appreciated.

Steve