LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 96
Default any link or formula to count cells with same color

To anyone helpful,
i have been trapped by a long formulation in order to list down series of
numbers. Yet due to conditional formatting with If(or conditions, the cells
has been provided with colors. My boss like me to count all the green ones
and the red ones in a single fire.

Please help me to count this long list of varying colored cells. My boss had
made an if formula on all the cells and he can instantly, change all the
colors in a single stroke.

anybody, please just try one shot'
happy holidays
dribler2
 
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
How to count blank cells that contain formula? IntricateFool Excel Discussion (Misc queries) 5 June 8th 06 02:45 PM
UDF is updateing cells on another sheet with count from current sheet. John Excel Discussion (Misc queries) 3 March 20th 06 03:58 PM
Is there an Excel formula to sum color filled cells? Alfred Kingfisher Excel Worksheet Functions 3 March 3rd 06 12:32 PM
how to count cells with specific format (background color)? Blackheartedowl Excel Discussion (Misc queries) 1 February 8th 06 08:21 AM
HOW TO FORMATE CELLS TO COUNT CELLS WITH A FILL COLOR? Moore New Users to Excel 1 June 15th 05 06:41 PM


All times are GMT +1. The time now is 06:45 AM.

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"