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

Biff

"Sam via OfficeKB.com" <u4102@uwe wrote in message
news:65cdea6908411@uwe...
Hi Biff,

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

The cells are formatted red when a specific ID is matched and its
associated
numeric value in the Dynamic Named Range "Data"

Cheers,
Sam

Biff wrote:
If the cells have cf applied to them then you should be able to write a
formula based on the logic that has been used in the cf'ing to find the
min/max.

Why are the cells formatted red?

Biff

Hi All,

[quoted text clipped - 9 lines]
Thanks,
Sam

--
Message posted via http://www.officekb.com