Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page counting colours
Register FAQ

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,948
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
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
__________________
Using O365 v2503 - 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 »


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 10:52 PM.

Contact Us - Privacy Statement - Top

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