Change cell color based on input in a range of cells [Solved/Closed]

diestra123 10 Posts Monday October 22, 2012Registration date July 15, 2013 Last seen - Oct 22, 2012 at 05:06 AM - Latest reply: diestra123 10 Posts Monday October 22, 2012Registration date July 15, 2013 Last seen
- 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!!!


See more 

2 replies

Best answer
rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Oct 22, 2012 at 08:45 AM
7
Thank you
In conditional format for A1, you can write
=COUNTIF(B2:J2,"Yes")>0

Thank you, rizvisa1 7

Something to say? Add comment

CCM has helped 1709 users this month

diestra123 10 Posts Monday October 22, 2012Registration date July 15, 2013 Last seen - Oct 22, 2012 at 10:06 AM
0
Thank you
problem solved. :)

thanks a lot rizvisa1!!!