count if certain font colour

MARRICK · Apr 7th, 2002, 04:03 PM

I have a range of values selected as the
current region (ctl *)
Certain values turn blue subject to a condition.
How could I count cells with the blue font
colour format?
Thanks in advance and grateful for any help

Mark W. · Apr 7th, 2002, 04:25 PM

Quote:

On 2002-04-07 15:03, MARRICK wrote:
I have a range of values selected as the
current region (ctl *)
Certain values turn blue subject to a condition.
How could I count cells with the blue font
colour format?
Thanks in advance and grateful for any help

Instead of counting cells with blue font count the cells that meets the condition.

Dave Hawley · Apr 7th, 2002, 07:26 PM

Hi MARRICK

Here is what you have asked for.
http://www.ozgrid.com/VBA/Sum.htm

brettvba · Apr 7th, 2002, 07:28 PM

Marrick Nice to see your keeping up with the ACE training infomation..

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

Apr 7th, 2002, 04:03 PM	#1
MARRICK New Member Join Date: Apr 2002 Posts: 2	I have a range of values selected as the current region (ctl *) Certain values turn blue subject to a condition. How could I count cells with the blue font colour format? Thanks in advance and grateful for any help

Apr 7th, 2002, 07:26 PM	#3
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi MARRICK Here is what you have asked for. http://www.ozgrid.com/VBA/Sum.htm

Apr 7th, 2002, 07:28 PM	#4
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	Marrick Nice to see your keeping up with the ACE training infomation..