Conditional formatting - highlight multiple cells based on matching values in adjacent rows

[ILoveSpreadsheets]

Hi

Hope someone can help. I've searched multiple forums
I have a table with text entries (e.g., A, B, C, D, E, etc) in a column. In an 'out of the way' part of the spreadsheet against each column value there are a list of values in a row, e.g., for A the values in the row are B, C, D. For B they are A, F, G, etc.

What I would like to do is to use conditional formatting (not VBA) and if a cell in the table contains an "X" to check the row values (in the 'out of the way part') and highlight the cells in its column that are adjacent to the same row values.

I have a screenshot of how I'd like this to work:

http://1drv.ms/1tER00R

EDIT - I can't seem to upload the image so please try the link instead. Thanks

 

[Special-K99]

Actual spreadsheets (dummy) are better than screenshots.
Screenshots mean we have to type in test data to provide a solution.
If you provide an actual spreadsheet then the test data is already there.

This is especially true of "this formula isn't working" type scenarios.

 

[ILoveSpreadsheets]

Thanks Special.

Please find a link to a dummy spreadsheet. I haven't set any formatting but hopefully it will help explain my problem:

http://1drv.ms/1rxcTzG