Seperate & Count Colored Characters

geeitsme

Board Regular
Joined
Mar 12, 2002
Messages
78
Im trying to do a formula to separate in the same column any cell with colored data.

Col A has Name of person
Col B-H has times i.e. 0800-1630 or 0600-0230
Cell B50 has formula =counta(b1:b49)
Cell B51 has formula =counta(b1:b49,"=off")

How would I separate any times that are in the color font blue from the black font.

Lets say col. B1-B20, B41, B44,45,46 have times in black font and B21-B40,42,43,47,48,49 are in blue font. What formula or macro should be used?

Any ideas?
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
Hi - what do you mean by "separate"? How did the cells get their coloour - manually? Conditional formatting? If manually, is there a 'rule' to when they get coloured?

Paddy
 

geeitsme

Board Regular
Joined
Mar 12, 2002
Messages
78
They are selected randomly. The color of font is changed at the toolbar font color. I manually click in the cell that I want to be in blue. Basically I need the count on all the times in black font and all the times that in the blue font.

I have not tried conditional formatting. I will try that in the mean time.
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
To count / sum by colour when the cells are coloured 'randomly', you'll be best off with a VBA solution - see the VBA pages on:

http://www.ozgrid.com/

...Dave has some 'sum & count by colour' examples...


Paddy
 

Forum statistics

Threads
1,144,328
Messages
5,723,730
Members
422,512
Latest member
MHau5

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
Top