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
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!!!
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!!!
Related:
- Excel change font color based on value of another cell
- Notepad++ change background color - Guide
- Html font color - Guide
- How to change date format in excel - Guide
- Change name of lg tv - Guide
- Excel mod apk for pc - Download - Spreadsheets
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Oct 22, 2012 at 08:45 AM
Oct 22, 2012 at 08:45 AM
In conditional format for A1, you can write
=COUNTIF(B2:J2,"Yes")>0
=COUNTIF(B2:J2,"Yes")>0
diestra123
Posts
9
Registration date
Monday October 22, 2012
Status
Member
Last seen
July 15, 2013
Oct 22, 2012 at 10:06 AM
Oct 22, 2012 at 10:06 AM
problem solved. :)
thanks a lot rizvisa1!!!
thanks a lot rizvisa1!!!
