counting the number of times a red number appears in a range

E

ecthree

Could somebody shed some light on how I can count the number of times a
red number appears in a range of cells? For now, I manually count the
number of times a red number appears in a range, but there has to be a
formula that will do this automatically.

Thanks,
Ed
 
J

JE McGimpsey

ecthree said:
Could somebody shed some light on how I can count the number of times a
red number appears in a range of cells? For now, I manually count the
number of times a red number appears in a range, but there has to be a
formula that will do this automatically.
Click to expand...

Take a look at Chip Pearson's site:

http://cpearson.com/excel/colors.htm
 
Top