If Column Contains "X" then highlight row

[Stilts15ak]

Hello All,

Hoping that someone can help me out.

I am currently trying to create a distribution list.

Down the left hand side in Column A (Name of person) & Column B (Email Address) Then Columns C through P are all of the different pieces of paperwork that need to get sent out. Under each piece of paperwork is an "X" indicating if that particular piece of paperwork needs to get sent out to that person. (More that one piece of paperwork can be sent out to an individual).

I would like with a drop down list (Say Cell "R2") that has all of the paperwork listed, when selected with the proper paperwork type selected highlight the name and email address of only those particular rows that have the "X" marked for that piece of paperwork. Taking also into account any additions added to the end of the list. The drop down list is easy enough to figure out. Link to view picture of sheet below.

Thank you for any help!

https://www.dropbox.com/s/v5icprrd8fpex5u/Highlight Row.jpg?dl=0

 

[onlyadrafter]

Hello,

select A2:P2 and select Conditional Formatting, and enter this formula

=INDEX($D2:$P2,0,MATCH($R$2,$D$1:$P$1,0))="X"

use the format painter to format other rows

 

[Stilts15ak]

Thank you onlyadrafter!

Didn't work at first, but just had to change the D column reference to C and it works like a charm!

Thank you!