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!!!


Related:

2 replies

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Oct 22, 2012 at 08:45 AM
In conditional format for A1, you can write
=COUNTIF(B2:J2,"Yes")>0
7
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