Font Color

[jaygreg]

Using Excel 2003. Made copy of a matrix I built years ago. Now want to
update it and show which cells have changed by making the font blue rather
than black. Too many changes to make by just changing the color after each
adjustment. Can't find anything that will permit me to change the font color
and make it the default while I finish the update. Can someone point me in
the right direction please?

 

[Bernard Liengme]

Have two copies on the matrix on the same worksheet.
Let's say one begins in A1 and the other in AA1
You will be updating the first matrix
Select all the first matrix; use Format | Conditional Formatting; set
Formula Is to =A1<>AA1 (do NOT use =$A$1<>$AA$1) and set the font to blue
Now when you change something in the first matrix it will display in blue.
best wishes

 

[Guest]

Do you want to change the whole cell or individual characters within a cell?

 

[jaygreg]

I may have been misleading. I've already made a copy and renamed it. That's
the one inwhich I will change selected cells. Everything I do with that
second copy will be a change so I'd like to have the default type color set
to blue rather than black. But I can't find the place where I'm given an
option to change font color as a default.

 

[Guest]

Put this tiny macro in worksheet code:

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Target.Font.ColorIndex = 5
Application.EnableEvents = True
End Sub

if you type in a cell the text will be blue.

 

[jaygreg]

I've got to write a macro just to change the color of type in Excel 2003?
Surely there's a check mark to make or button to push somewhere.

But if all else fails... thanks for the info.

 

[Guest]

Sadly the font color is a property of the cell.