Change cell color based on input in a range of cells
Solved/Closed
diestra123
Posts
10
Registration date
Monday October 22, 2012
Status
Member
Last seen
July 15, 2013
-
Oct 22, 2012 at 05:06 AM
diestra123 Posts 10 Registration date Monday October 22, 2012 Status Member Last seen July 15, 2013 - Oct 22, 2012 at 10:06 AM
diestra123 Posts 10 Registration date Monday October 22, 2012 Status Member Last seen July 15, 2013 - Oct 22, 2012 at 10:06 AM
Related:
- How to change cell color in excel based on text input
- Html input text color - Guide
- Notepad++ change background color - Guide
- How to change author in excel - Guide
- How to change date format in excel - Guide
- How to calculate position in excel ✓ - Office Software Forum
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
10
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!!!