Change cell color based on input in a range of cells

Solved/Closed

diestra123 Posts 9 Registration date Monday 22 October 2012 Status Member Last seen 15 July 2013 - 22 Oct 2012 à 05:06
diestra123 Posts 9 Registration date Monday 22 October 2012 Status Member Last seen 15 July 2013 - 22 Oct 2012 à 10:06

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
Change font color html - Guide
How to change date format in excel - Guide
How to change notepad background color - Guide
Color 65535 - Guide
How to change font in facebook post - Guide

2 responses

Réponse 1 / 2

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

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

Réponse 2 / 2

diestra123 Posts 9 Registration date Monday 22 October 2012 Status Member Last seen 15 July 2013
22 Oct 2012 à 10:06

problem solved. :)

thanks a lot rizvisa1!!!

Similar discussions

Excel VBA - Change cell color based on value

How do I change a base location on Instagram?

Conditional Format Cells Based on Another Cell and Own Cell

Similar discussions

Subscribe To Our Newsletter!