Questions on conditional formatting

harky

Active Member
Joined
Apr 8, 2010
Messages
297
Hi,
Possible to use conditional formatting to 'sum count' font colour?

1
2

The ans should be 2 'count'
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,341
Condtional formatting cant read the color of a cell, you need VBA for that.
If the colour has been set by conditional formatting then just use the same conditions to count the number of colours.
 

Watch MrExcel Video

Forum statistics

Threads
1,089,976
Messages
5,411,618
Members
403,383
Latest member
Excelacity

This Week's Hot Topics

Top