Conditional Formatting to Highlight Specific Row in Data Set

[Jeffrey Lebowski]

I have been playing around in Excel and I have some US presidential data that I want to make a little interactive. I am really just messing around with INDEX(MATCH()) and Conditional Formatting.

Right now I have it set up in cell B2 that you can select an ID tied to a specific president with data validation. This selection will basically regurgitate the entire row from within the table.

I have set up Conditional Formatting to try and highlight this specific row within the table. Based on the criteria I give in the Conditional Formatting, the problem I am running into is when there are more than 1 of the same value in the table, multiple cells are highlighted and not just the cells in the one row that I want highlighted.

Can someone please help me understand a more logical argument to have the conditional formatting do exactly what I want?

 

[Nebu]

Hope this is what you are looking for ....

 

[Hui]

If you take Nebu's file
You can delete the second CF
You simply need the first one which is =$B8=$N$1

What this says is that for every cell in the range B8:M51
Note that the B8 corresponds to the CF's $B8
If the cell in the range B8:M51 has the same row as the cell in $B8 and the value in B8 is equal to the value of cell $N$1, then apply the CF

Note that the cell N1 is the same for all cells in the range B8:M51 as N1 islocked by the two $ signs $N$1

 

[Jeffrey Lebowski]

Thank you Nebu & Hui!

Can anyone explain why N1 is needed and why the CF cannot just be =$B8=$B$1 ??

** Nevermind! The CF can be made simpler! **

 

[Nebu]

Hi:

I have made it simpler I had to Format your drop down and the IDs its working with the reference from your drop down now... see the attached