LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A UDF for Counting Coloured Cells that are conditionally formatted NeilG New Users to Excel 5 November 1st 09 12:45 AM
Conditionally Formatted Cells amy Excel Discussion (Misc queries) 1 February 23rd 08 07:28 AM
Can you add the number of conditionally formatted cells?? Lost Excel Worksheet Functions 1 January 23rd 07 06:31 AM
Counting conditionally formatted cells Kebbon Excel Worksheet Functions 2 October 12th 06 01:48 PM
Counting colour formatted cells Hood Excel Worksheet Functions 2 June 23rd 06 03:14 PM


All times are GMT +1. The time now is 12:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"