Conditional Formatting Formula

[scott_86_]

Hi,

Can anyone help me out with achieving the following with a formula for conditional formatting:

• A2 will turn green when cells B2:M2 all have the value of C.
• A2 will be red when any one of the of the cells in B2:M2 do not have the value of C.

Thank you!

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Is this what you want?

23 03 06.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Date
2		C	C	C	C	C	C	C	C	C	C	C	C
3			C	C	C	C	C	C	C	C	C	C	C
4
5		C	C	C	C	C	C	C	C	C	C	C
6		C	C	C	C	C	C	C	C	C	C	C	C
7		C	C	C	C	M	C	C	C	C	C	C	C
8
9		c	c	c	c	c	c	c	c	c	c	c	c
10
CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A10	Expression	=COUNTIF(B2:M2,"C")<12	text	NO
A2:A10	Expression	=COUNTIF(B2:M2,"C")=12	text	NO

 

[scott_86_]

Thanks, Peter, that worked as intended.

I've updated my account as well based on your advice.

Cheers.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.

.. and for updating your details.