Hi Biff,

Sample Data using ID 10621

Cell Ref H13 = 10621
Column "G" = Numeric Labels
Column "H" = Frequency Values

Column "G" Column"H"
Numeric Label Frequency
Row17 90 10
Row18 480 7
Row19 80 5
Row20 60 4
Row21 50 4
Row22 470 3
Row23 430 2
Row24 420 1


ID 10621 will have several Numeric Labels in its row. If any of the above
Numeric Labels match with ID 10621 associated row values then the Numeric
Label's adjacent Frequency value should be highlighted in Red.

The Numeric Labels are defined in a 12 column by many rows Dynamic Named
Range called "Data".

This is the Conditional Format Formula
=COUNTIF(INDEX(Data,MATCH($H$13,ID,0),0),$G17)

CF Formula applied to column "H" (Frequency values)


Cheers,
Sam

Biff wrote:
Need the details. A small chunk of sample data with expected result would
help.

Biff

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200609/1