Changing colour of cell once multiple other cells contain text
Closed
VanessaR
-
Aug 18, 2016 at 06:13 AM
fdibbins Posts 33 Registration date Sunday June 19, 2016 Status Contributor Last seen November 20, 2016 - Aug 19, 2016 at 10:23 PM
fdibbins Posts 33 Registration date Sunday June 19, 2016 Status Contributor Last seen November 20, 2016 - Aug 19, 2016 at 10:23 PM
Related:
- Changing colour of cell once multiple other cells contain text
- Rj45 colour code - Guide
- Multiple whatsapp on desktop - WhatsApp Forum
- Cell phone codes - Guide
- Based on the values in cells b77 b88 - Excel Forum
- Excel cell color formula - Guide
1 response
fdibbins
Posts
33
Registration date
Sunday June 19, 2016
Status
Contributor
Last seen
November 20, 2016
1
Aug 19, 2016 at 10:23 PM
Aug 19, 2016 at 10:23 PM
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =and(B2<>"",G2<>"",K2 <>"") format fill GREEN
For the other, you could create a new rule and reverse the rule (="" instead or <>"")
OR you could just regular format all cells to red, and let the CF rule change to green when they are filled in?
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =and(B2<>"",G2<>"",K2 <>"") format fill GREEN
For the other, you could create a new rule and reverse the rule (="" instead or <>"")
OR you could just regular format all cells to red, and let the CF rule change to green when they are filled in?
