Change cell color based on input in a range of cells

Solved/Closed

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

Excel change font color based on value of another cell
Notepad++ change background color - Guide
Html font color - Guide
How to change number of best friends on snapchat - Guide
How to change date format in excel - Guide
How to change author in excel - Guide

2 responses

Answer 1 / 2

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Oct 22, 2012 at 08:45 AM

In conditional format for A1, you can write
=COUNTIF(B2:J2,"Yes")>0

Answer 2 / 2

diestra123 Posts 9 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!!!

Similar discussions

help me to add particular cells

How to convert the tamil pdf file to tamil word file

Similar discussions

Subscribe To Our Newsletter!