Conditinal formatting in a table, multiple rows

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 w...

excel

Formulas and Functions

HansVogelaar
Jan 30, 2022
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.