4 Replies Latest reply: Sep 12, 2013 11:21 AM by Allan Jones
mcrawfo3 Level 1 Level 1 (0 points)

Hello,

 

I am trying to use conditional formatting on a cell (let's call it H1) that already has a formula in it. The cell is an average of 7 other cells (A1-G1). I want to highlight H1 only when 3 of the 7 cells (A1-G1) are filled. Basically I don't want to create an average in H1 if it is creating an average of only 3 cells and I want an easy indication of those cells where there is text in only 3 of the 7 cells!

 

Can someone help me out?

 

Thanks,

 

Megan