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

 
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
Colorindex and conditional formatting Libby Excel Programming 2 August 21st 09 06:46 PM
Conditional Formatting and Interior.ColorIndex Farrar > Tweety Excel Programming 3 March 26th 08 03:42 AM
How to get cell colorindex of conditional formatted cells [email protected] Excel Discussion (Misc queries) 5 December 2nd 06 01:07 PM
Count Rows with Conditional Format? Ken Excel Discussion (Misc queries) 3 March 24th 05 02:27 PM
Colorindex in a Conditional Format Frank Kabel Excel Programming 3 July 23rd 04 09:18 PM


All times are GMT +1. The time now is 12:31 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"