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
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

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