Conditional formatting - based on a single cell lookup in a range

[rfj1001]

I want to change the background colour of a column header (cell C2) to Green only if one of the cells in the column (C3-C12) has the character C in it. Any other characters, or more than one C, etc. should not change the colour.

Can SKS help out as I just can't seem to get a formula that works.

Version is Excel 365

Many thanks

Rob

 

[rfj1001]

If your intention is to have the column header highlighted if there is only one "C" in only one cell, then try this:

=AND(COUNTIF(C3:C12,"*C*")=1,COUNTIF(C3:C12,"*C*C*")=0)

If it's something else, then try posting an example.

Thanks Tetra201. That was what I was trying to achieve. Works a dream

 

[Tetra201]

You are welcome.