Font Color

[komobu]

Every year when I do my taxes, I take last years excel tax work sheet and copy it. Then I take all dollar values and change the font to red. This way I know they are last year values that havent yet been updated. When I type in the current values for this year, I want the font to be black. This way I know what has been updated and what hasnt.

The problem is excel makes it difficult to change the font color and I think there must be an easier way or a work around. Let me describe it like this...

Last Years donations were 7695. (in red font)
This years donations were 8100. I enter 8100 and the font remains red. I now have to click out side the cell, then click back into the cell, then click the black font button to change the 8100 value to black.

When I do my taxes, I must have over 300 cells that have to be changed from red to black. That is a lot of clicking from out of the cell, back into the cell, and then the black font.

Is there a way that no matter what the cell font color currently is, when I type in a value in it will be in black font?

Thanks for any help

 

[nemmi69]

You could highlight all the cells and create an on condition that if value >0 then font = black , background = white.

 

[komobu]

You could highlight all the cells and create an on condition that if value >0 then font = black , background = white.

Then since last year values are greater than 0, wouldnt they turn back to black? I want them in red so I know they are last year values and not current.