counting colored cells

T

ttowncorp

Board Regular
Joined
Feb 2, 2015
Messages
188
Office Version
  1. 365
Platform
  1. Windows
is there a simple way to add up colored cells on your sheet by rows or columns. how many yellows do I have in this row or column etc.
 
Last edited:

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Sort by date Sort by votes
Have a look at the following link...

Code: 
http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm

Hope this helps!
 
Upvote 0
If they are set by conditional formatting just use the same set of conditions to count them otherwise its a VBA job.
 
Upvote 0
You must log in or register to reply here.

Similar threads

H
  • Question Question
VBA Pivot Table Dynamic Range & Only One Selection per Row
Replies
3
Views
377
DanteAmor
DanteAmor
D
  • Question Question
Conditional formatting - Formula is changing the Table header color from the standard blue color to one of the below formatting colors
Replies
2
Views
86
DennisYoung
D
V
  • Question Question
Collecting data from the cells
Replies
0
Views
91
vikosh
V
D
  • Solved
Color Cell interiors in one sheet row range based on cells manually colored on another sheet.
2
Replies
13
Views
635
mumps
mumps
R
  • Question Question
Color count Conditional Formatting Via rows into total columns
Replies
5
Views
206
6StringJazzer
6StringJazzer

Forum statistics

Threads
1,226,114
Messages
6,189,051
Members
453,522
Latest member
Seeker2025

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top