Conditional Formatting

[JorgenKjer]

Hi

Is there anyone who can help?

If the value "X" is one or more times in column B2 to B101, the background color in cell B1 must turn green.

If no "X" in column B2 to B101, the background color must be yellow.

I would appreciate it very much if anyone has a solution

Thanks in advance.



Yours sincerely

Jorgen

 

[Joe4]

You can set up two Conditional Formatting formulas on cell B1 (using the formula options of conditional formatting).

Rule 1:
CF formula: =COUNTIF(B2:B101,"X")>0
Choose green formatting option.

Rule 2:
CF formula: =COUNTIF(B2:B101,"X")=0
Choose yellow formatting option.

 

[JorgenKjer]

Hi joe4

Thanks for your prompt reply
Your solution is absolutely perfect
Thank you

Yours sincerely
Jorgen

 

[Joe4]

You are welcome.
Glad I was able to help!