Font Color

komobu

New Member
Joined
Feb 7, 2011
Messages
34
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
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

nemmi69

Active Member
Joined
Mar 15, 2012
Messages
457
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. Windows
You could highlight all the cells and create an on condition that if value >0 then font = black , background = white.
 

komobu

New Member
Joined
Feb 7, 2011
Messages
34
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,491
Messages
5,523,255
Members
409,506
Latest member
reneekeane

This Week's Hot Topics

Top