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
- Conditional formatting if cell contains text ✓ - Excel Forum
- Based on the cell values in cells b77 ✓ - Excel Forum
- How to rotate multiple pictures at once windows 10 - Guide
- How to download multiple files from whatsapp web - WhatsApp Forum
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?
