Share via

How to color cells in Excel based on a column group value?

Anonymous
2023-07-10T23:23:32+00:00

This question is a bit hard to explain generally, so I'll explain what I'm specifically doing and ask regarding that.

I have a spreadsheet with a list of users. For each user, their manager is listed. I want to color the cells so that all the users for manager A are this color, all the users for manager B are another color, etc. So the color would be grouped by manager.

Is there an easy way to do this?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-07-11T01:25:13+00:00

    You may use conditional formatting to set the color. One rule for one manager.

    =$A2="Manager1"

    0 comments
  2. Anonymous
    2023-07-11T15:49:45+00:00

    That sounds like a good solution, thank you.

    Can you provide way more detail on how to actually do what you just suggested? I am a very basic Excel user. I'm not familiar with formulas or formatting. I tried to recreate what you did here but none of my attempts were successful.

    0 comments
  3. Anonymous
    2023-07-11T15:57:55+00:00

    Share a test file in private message, then we can put the formula for you and send back to you.

    0 comments