hI,

I think you mean is negative value that Excel format them
automatically as red for the font color.

You don't need to subtract the total trough VBA, because
Excel will subtract them

Regards,

Halim

gypsyatheart menuliskan:
I would like to create a spread sheet that when something is written in Red
text in a cell that it will subtract one from the total. Is Excel able to do
this?