Conditinal formatting in a table, multiple rows

[roboed]

Hi.

In such a table, how do I highlight with colour both instances of "Company A" (B2 and B3), when just putting an "x" in C2? Same for Company B and so on.

The file contains many more columns with different data in, and someone is to go through and mark the one correct column for each company. I then want to highlight ALL rows for that company as the review of it is done. I can create additional helper columns if needed.

	A	B	C
1	ID	Name	Keep row = x
2	111	Company A	x
3	111	Company A
4	222	Company B
5	222	Company B	x
6	222	Company B

[#2 · Accepted solution]

@roboed 

The Name column, starting in row 2.

B2 should be the active cell in the selection.

On the Home tab of the ribbon, select Conditional Formatting > New Rule...

Select 'Use a formula to determine which cells to format'.

Enter the formula =COUNTIFS($B$2:$B$100,$B2,$C$2:$C$100,"x")

Adjust the ranges as needed.

Click Format...

Specify the desired formatting, for example in the Fill tab.

Click OK, then click OK again.

[#3]

Thanks, worked great. I was thinking too advanced :)