Sam

How did the numbers' font get colored red? Manually or through Conditional
Formatting?

If by CF, sum on that criteria.

If manually, Excel has no built-in Function for that.

You will need a User Defined Function.

Chip Pearson has one.

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

Look for CellColorIndex UDF and read Chip's instructions on usage.


Gord Dibben Excel MVP

On Fri, 4 Mar 2005 13:29:03 -0800, Sam wrote:

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