View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Count the Colorindex of a cell with a conditional format

Barb,

I answered no to this once and Bob Philips corrected me and pointed me
towards his page below. You can count conditionally formatted cells but it
ain't easy.

http://www.xldynamic.com/source/xld.CFConditions.html
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Barb Reinhardt" wrote:

Is there any way (with or without code) to count the number of cells that
have a condition that displays a specific colorindex tied to a conditional
format?

Thanks,

Barb Reinhardt