How can I count cells based on their fill color that was set by conditional format

		Microsoft Office Forums > Microsoft Excel > Excel Programming
How can I count cells based on their fill color that was set by conditional format

FAQ

Mark Forums Read

Thread Tools

Display Modes

10-21-2013, 11:04 AM

trueimage

Windows 7 64bit How can I count cells based on their fill color that was set by conditional format

Office 2010 32bit

Novice

Join Date: Sep 2013

Posts: 4

How can I count cells based on their fill color that was set by conditional format

I have a range of cells that has conditional format applied to fill the cell with yellow for example.

I want to be able to get a count of how many of those cells are filled yellow. The normal "count by color" formulas don't seem to work because of the conditional formatting.

I'd like the count to be updated whenever any cell in the workbook is updated.

Any help would be appreciated

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count Conditional Formatting?	tinfanide	Excel	2	10-18-2013 06:19 AM
How-TO format cells (FILL) by comparing cells	zanat0s	Excel	1	07-03-2012 04:27 AM
Conditional color fill based on presence of data	avanderh	Excel	11	07-28-2011 09:10 AM
How can I fill cell color starting from Cell D5 using Conditional formatting instead	Learner7	Excel	0	07-08-2010 05:50 AM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:42 AM.