View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Counting a colour that is Conditionally Formatted

On Sat, 08 Nov 2003 14:14:52 -0500, Crash wrote:

I have a grid that conditionally formats the background colour to Green,
Red or White depending on a criteria. I want to count the number of
times green appears in a row. I've tried modifying the CountByColor
Function but to no avail.

Is this possible?

TIA

Jon


I do not believe so. You would need your code to check for the *condition*
that produces the Green result.


--ron