How to Highlight Entire Row by Name?

Question

How to Highlight Entire Row by Name?

Anonymous

I have an excel sheet at my company which has all the employees and their relevant certifications and degrees formatted into a table with each row having one cert/degree on it. To make reading this sheet easier my boss wants the rows, by employee, alternating between gray and white. So far I've been doing this manually but when we gain or lose an employee I have to redo the shading for the whole document because it's arranged alphabetically. Is there a way that I can automatically format the groups to make this less tedious?

For example:

Let's say I have Bill A, Susan B, and Tom C. Each of them has 5 rows of certifications. I want all of Bill and Tom's rows to be gray, and all of Susan's rows to be white.

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

Answer accepted by question author

0 additional answers

Answer 1

Hi Copo55

Try the following steps

1- Create an index column as a unique identifier for each employee as shown in the picture below in column A (could be another column, ... it's your choice)

2- Select the entire table range.

3- Use the following formula for the Conditional Formatting rule =ISODD($A2)

4- Select the Grey color tone of your preference

IMPORTANT NOTES:

a) Adapt your CF formula according to your real scenario.

b) Make sure the first INDEX cell-row in your table range matches the range in the formula.

In the sample picture below cell A2 is the first INDEX cell-row, hence the formula is =ISODD($A2)

c) Lock the column in the formula with $, but not the rows.

Results

Do let me know if you need more help

On the other hand,

If the answer helped you.

Please, consider marking this thread as answered.

It would help others in the community with similar questions or problems.

Thank you in advance

Regards

Jeovany

Share via

How to Highlight Entire Row by Name?

0 additional answers