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
- How to delete multiple files at once - Guide
- Crimping colour code - Guide
- Conditional formatting if cell contains text - Excel Forum
- Which key is used to make multiple line in a single cell - Guide
- How would you change all cells containing the word pass to green - Excel 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?
