Thread: Return Min & Max value of Conditional Formatted cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
  
Posts: 10,593
Default Return Min & Max value of Conditional Formatted cells
See http://www.xldynamic.com/source/xld.ColourCounter.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"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



Reply With QuoteReply With Quote