View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default Return Min & Max value of Conditional Formatted cells

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