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

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


See more 

2 replies

Best answer
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
7
Thank you
In conditional format for A1, you can write
=COUNTIF(B2:J2,"Yes")>0

Thank you, rizvisa1 7

A few words of thanks would be greatly appreciated. Add comment

CCM has helped 2601 users this month

Posts
10
Registration date
Monday October 22, 2012
Last seen
July 15, 2013
0
Thank you
problem solved. :)

thanks a lot rizvisa1!!!