Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page counting colours
Register FAQ Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 12-28-2013, 12:45 PM
not_dave not_dave is offline counting colours Windows 7 64bit counting colours Office 2007
Novice
counting colours 		 
Join Date: Dec 2013
Posts: 1
not_dave is on a distinguished road
Default counting colours

is there a formula i can use to count the amount of cells in a column that are filled in a specific colour.
Reply With Quote
  #2  
Old 12-29-2013, 01:27 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline counting colours Windows 7 64bit counting colours Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,669
Pecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud of
Default
Hi
there is a possible solution at http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm.

Otherwise Google around, this is a known problem
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Tags
formula

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Novice having problems with colours. Simoninparis Excel Programming 2 02-29-2012 03:28 AM
counting colours Simplifying the work. (colours) Anderlfs Word 8 03-25-2011 02:57 PM
Font colours wolff Word 0 01-26-2010 08:03 PM
Font Colours Nissan Micrasoft Word 0 01-04-2010 06:10 AM
Font Colours fred bionics PowerPoint 1 10-18-2009 09:53 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:15 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft