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

[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

 

[JE McGimpsey]

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.

Take a look at Chip Pearson's site:

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