Font Color

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jaygreg - 26 Jun 2007 14:30 GMT

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?

Reply to this Message

Bernard Liengme - 26 Jun 2007 14:47 GMT

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

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> 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?

Reply to this Message

Gary''s Student - 26 Jun 2007 14:50 GMT

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

Signature

Gary''s Student - gsnu200733

> 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?

Reply to this Message

jaygreg - 26 Jun 2007 18:22 GMT

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.

> Do you want to change the whole cell or individual characters within a
> cell?
[quoted text clipped - 9 lines]
>> in
>> the right direction please?

Reply to this Message

Gary''s Student - 27 Jun 2007 00:06 GMT

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.

Signature

Gary''s Student - gsnu200733

> 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
[quoted text clipped - 15 lines]
> >> in
> >> the right direction please?

Reply to this Message

jaygreg - 27 Jun 2007 13:28 GMT

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.

> Put this tiny macro in worksheet code:
>
[quoted text clipped - 28 lines]
>> >> in
>> >> the right direction please?

Reply to this Message

Gary''s Student - 27 Jun 2007 21:36 GMT

Sadly the font color is a property of the cell.

Signature

Gary''s Student - gsnu200733

> 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.
[quoted text clipped - 33 lines]
> >> >> in
> >> >> the right direction please?

Reply to this Message