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
"Sam via OfficeKB.com" <u4102@uwe wrote in message
news:65cb4431d96cf@uwe...
Hi All,
Is this possible with a Formula?...
I would like to retrieve the Minimum and Maximum from numerous columns
with
cells that already have Conditional Formatting applied to them. The CF
formats the cell interior red. Can the Min and Max values be found within
the
CF red interior cells and returned to an empty cell.
Thanks,
Sam
--
Message posted via http://www.officekb.com