Where did you store the ColorIndex function? You did save it in your
workbook I presume?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sam" wrote in message
...
BTW, I am using Excel 2003, Service Pack 1.

"Bob Phillips" wrote:

Take a look at the solution at
http://www.xldynamic.com/source/xld.ColourCounter.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sam" wrote in message
...
I have a column of numbers. Some are black, some are red. I cannot
sort
the
red numbers to a specific section. Is there a way of adding just the
red
numbers? I was thinking of placing my cursor in an adjacent column
(say
column D) and using some sort of of IF formula like: IF C3= red
fonted
number, then place it here, otherwise leave blank.

Anyone with any ideas? Thanks to anyone who takes the time to respond!

Sam