Change cell color based on input in a range of cells

Solved/Closed
Report
Posts
10
Registration date
Monday October 22, 2012
Status
Member
Last seen
July 15, 2013
-
Posts
10
Registration date
Monday October 22, 2012
Status
Member
Last seen
July 15, 2013
-
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 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
In conditional format for A1, you can write
=COUNTIF(B2:J2,"Yes")>0
7
Posts
10
Registration date
Monday October 22, 2012
Status
Member
Last seen
July 15, 2013

problem solved. :)

thanks a lot rizvisa1!!!
0