View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default Count the Colorindex of a cell with a conditional format

Are we talking about the same Conditional Format formula for the color... or
could there be different Conditional Format formulas that display the same
color? Also, is there only going to be one conditional test per cell... or
could the cell have multiple test? Also, are we talking about counting cells
with that currently displaying the color as a result of the conditional test
being TRUE... or just cells with a conditional test that **could** produce
the color if the test evaluates to TRUE, whether it is TRUE now or not?

--
Rick (MVP - Excel)



"Barb Reinhardt" wrote in message
...
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