Changing colour of cell once multiple other cells contain text
Closed
VanessaR
-
18 Aug 2016 à 06:13
fdibbins Posts 33 Registration date Sunday 19 June 2016 Status Contributor Last seen 20 November 2016 - 19 Aug 2016 à 22:23
fdibbins Posts 33 Registration date Sunday 19 June 2016 Status Contributor Last seen 20 November 2016 - 19 Aug 2016 à 22:23
Related:
- Changing colour of cell once multiple other cells contain text
- How to change text colour html - Guide
- Excel multiple lines in one cell - Guide
- Rj45 colour code - Guide
- How to delete cells in word - Guide
- Excel arrow keys not moving cells - Guide
1 response
fdibbins
Posts
33
Registration date
Sunday 19 June 2016
Status
Contributor
Last seen
20 November 2016
1
19 Aug 2016 à 22:23
19 Aug 2016 à 22:23
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?
