Conditional Format Column based on Lookup to Diff. Sheet

Hello all,

I was wondering if it were possible to do a conditional format on a column based on a reference to a different sheet. For example, I have a table in my first sheet with attributes. Any time an attribute is used by a specific code, I mark an X in the cell for that code. Now, I want to be able to highlight those X's in red if they match the standard attributes for that code in the second sheet. In the attached sheet, the scale has been significantly reduced to make it easier to see, but I plan on doing this for a much larger data set. Any help would be greatly appreciated!

Thanks

Hello
Select the range of cells and apply the following CF formula:

=COUNTIF(INDEX('Ref. Table'!$B$2:$G$13,0,MATCH(B$1,'Ref. Table'!$B$1:$G$1,0)),$A2)

Whatever font format you've chosen should be applied.

DBY