Well, this is something I would need to see for myself. I'm just not getting
a good "picture" of the data. If you want to/can send me a copy of the file
I'll get a better idea of what needs to be done. I'm at:
xl can help at comcast period net
Remove "can" and change the obvious.
Biff
"Sam via OfficeKB.com" <u4102@uwe wrote in message
news:65cf486263e96@uwe...
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