Changing colour of cell once multiple other cells contain text

[Closed]
Report
-
Posts
33
Registration date
Sunday June 19, 2016
Status
Contributor
Last seen
November 20, 2016
-
Hello,
I would like to indicate in a cell at the beginning of a row whether multiple 'mandatory' cells within the row contain text. Red for incomplete, green for complete

So.. If B2,G2 and K2 contain text, A2 would colour green.

Thanks in advance


1 reply

Posts
33
Registration date
Sunday June 19, 2016
Status
Contributor
Last seen
November 20, 2016
1
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?