Font Color

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?

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 =A1AA1 (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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"jaygreg" wrote in message
...
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?

Do you want to change the whole cell or individual characters within a cell?
--
Gary''s Student - gsnu200733


"jaygreg" wrote:

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?

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.


"Gary''s Student" wrote in message
...
Do you want to change the whole cell or individual characters within a
cell?
--
Gary''s Student - gsnu200733


"jaygreg" wrote:

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?

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.
--
Gary''s Student - gsnu200733


"jaygreg" wrote:

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.


"Gary''s Student" wrote in message
...
Do you want to change the whole cell or individual characters within a
cell?
--
Gary''s Student - gsnu200733


"jaygreg" wrote:

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?

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.


"Gary''s Student" wrote in message
...
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.
--
Gary''s Student - gsnu200733


"jaygreg" wrote:

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.


"Gary''s Student" wrote in
message
...
Do you want to change the whole cell or individual characters within a
cell?
--
Gary''s Student - gsnu200733


"jaygreg" wrote:

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?

Sadly the font color is a property of the cell.
--
Gary''s Student - gsnu200733


"jaygreg" wrote:

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.


"Gary''s Student" wrote in message
...
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.
--
Gary''s Student - gsnu200733


"jaygreg" wrote:

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.


"Gary''s Student" wrote in
message
...
Do you want to change the whole cell or individual characters within a
cell?
--
Gary''s Student - gsnu200733


"jaygreg" wrote:

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?