mcrawfo3
Level 1 (0 points)

Q: How to use conditional formatting for multiple cells

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

Posted on Sep 12, 2013 9:55 AM

by Allan Jones,Solvedanswer
Allan Jones Allan Jones
Level 8 (35,316 points)
iPad
A:

Hi Megan,

 

It's pretty complicated for explanation in this forum setting. I think you will be better served by asking in Microsoft's Office:Mac forums here:

 

Office for Mac forums

 

There are a lot of Mac-using Excel gurus there. Be sure to tell them your verison of Excel when you post--it could make a difference.

Posted on Sep 12, 2013 10:50 AM

Close
mcrawfo3

Q: How to use conditional formatting for multiple cells

  • All replies
  • Helpful answers

  • by mcrawfo3,

    mcrawfo3 mcrawfo3 Sep 12, 2013 10:12 AM in response to mcrawfo3
    Level 1 (0 points)
    Sep 12, 2013 10:12 AM in response to mcrawfo3

    Edit: this is in excel btw

  • by Allan Jones,Solvedanswer

    Allan Jones Allan Jones Sep 12, 2013 10:50 AM in response to mcrawfo3
    Level 8 (35,316 points)
    iPad
    Sep 12, 2013 10:50 AM in response to mcrawfo3

    Hi Megan,

     

    It's pretty complicated for explanation in this forum setting. I think you will be better served by asking in Microsoft's Office:Mac forums here:

     

    Office for Mac forums

     

    There are a lot of Mac-using Excel gurus there. Be sure to tell them your verison of Excel when you post--it could make a difference.

  • by mcrawfo3,

    mcrawfo3 mcrawfo3 Sep 12, 2013 11:05 AM in response to Allan Jones
    Level 1 (0 points)
    Sep 12, 2013 11:05 AM in response to Allan Jones

    Hi Allan,

     

    Thanks for the tip, I will try in the microsoft office forum.

    BTW- is this your way of saying you have no idea

    Megan

  • by Allan Jones,

    Allan Jones Allan Jones Sep 12, 2013 11:21 AM in response to mcrawfo3
    Level 8 (35,316 points)
    iPad
    Sep 12, 2013 11:21 AM in response to mcrawfo3

    BTW- is this your way of saying you have no idea

     

    Fair question! The answer is "not exaclty."

     

    I used Excel a lot when I was a working engineer but am retired now, so I'd have to almost see your sheet and work through it to refresh my conditional formatting recollections. I used CF a lot then but haven't had too many reasons to do so since. Almost all MS Word now.

     

    So yes, I have Excel experience, but it is rusty and I figured you'd get faster help in the MS forums. I have a boilerplate answer for when I don't know squat:

     

    DOH!

     

    Can you post back if the other forum has what you need?