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