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
Excel formula for color of cell - Guide
How to change date format in excel - Guide
Change name of lg tv - 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

Fill adjacent cell with number from text answer

How to convert the tamil pdf file to tamil word file

Similar discussions

Subscribe To Our Newsletter!