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
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
758
In conditional format for A1, you can write
=COUNTIF(B2:J2,"Yes")>0
7
Thank you

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

CCM 3376 users have said thank you to us this month

Posts
10
Registration date
Monday October 22, 2012
Status
Member
Last seen
July 15, 2013

problem solved. :)

thanks a lot rizvisa1!!!