Previous Topic Next Topic

Change cell color based on input in a range of cells

Solved/Closed
diestra123 Posts 10 Registration date Monday October 22, 2012 Status Member Last seen July 15, 2013 - Oct 22, 2012 at 05:06 AM
diestra123 Posts 10 Registration date Monday October 22, 2012 Status Member Last seen July 15, 2013 - Oct 22, 2012 at 10:06 AM
Hello everyone,
I have formatted a cell based on a specific text entered in one cell. Example, A1 will turn green if I write "yes" on B2, using conditional formatting. But I want to use a range of cells, say B2:J2. If "yes' appear in any one of these cells, A1 will turn green. Any help would be appreciated. Thanks!!!


2 responses

Answer 1 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Oct 22, 2012 at 08:45 AM
In conditional format for A1, you can write
=COUNTIF(B2:J2,"Yes")>0
7
Answer 2 / 2
diestra123 Posts 10 Registration date Monday October 22, 2012 Status Member Last seen July 15, 2013
Oct 22, 2012 at 10:06 AM
problem solved. :)

thanks a lot rizvisa1!!!
0

Similar discussions

How do I change a base location on Instagram?
rebelkids -
38nancy -

8 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Can you rename the inputs on LG Smart TV (WebOS)?
sjdunning -
dhh1 -

4 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Ig stories from close friends to public
Darren -
zara -

31 responses