Highlight entries one list if they appear in an associated list

Closed
ExPatBrit Posts 2 Registration date Tuesday August 19, 2014 Status Member Last seen August 19, 2014 - Aug 19, 2014 at 12:18 PM
I wish to highlight entries in one list if they appear in an associated list:
I chose to do this by using a modified COUNTIF function, which I had tested as a stand-alone formula [=(COUNTIF((Allocation_Codes_Table),(A8)))] which gave me a count of 1 where appropriate.

So, for Conditional Formatting, I need to check if COUNT=1 to indicate it found one;
so, CondFormat inserts ="((COUNTIF(('Monthly Allocations'!U8:AI53),(A15)))=1)" ... HOWEVER, it does embolden the cell !!

Any assistance please ?