Jan 30 2022 02:41 PM - edited Jan 30 2022 02:43 PM
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 |
Jan 30 2022 02:48 PM
SolutionThe 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.
Jan 30 2022 02:57 PM
Jan 30 2022 02:48 PM
SolutionThe 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.