Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Font Color
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 -- 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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Font Color
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? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Font Color
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? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Font Color
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? |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Font Color
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? |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Font Color
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I conditionally change font color, or background color? | Excel Worksheet Functions | |||
trouble with viewing fill color and font color | Excel Worksheet Functions | |||
How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) | |||
My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) |