A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

type in a different color



 
 
Thread Tools Display Modes
  #1  
Old June 19th, 2006, 07:49 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default type in a different color

Is there anyway to set my font color to a specific color as I type? I want
to make changes to cells and see what cells have been changed by the color of
the font.
I don't like the way the "track changes highlighting" prints out. Thanks!


  #2  
Old June 19th, 2006, 07:59 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default type in a different color

Hi GMed,

try to use the TOOLS | CHANGES CONTROL

Hope this helps
regards from Brazil
Marcelo

"GMed" escreveu:

Is there anyway to set my font color to a specific color as I type? I want
to make changes to cells and see what cells have been changed by the color of
the font.
I don't like the way the "track changes highlighting" prints out. Thanks!


  #3  
Old June 19th, 2006, 08:03 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default type in a different color

I don't see that in my tools menu, is it an add in feature? Thanks!

"Marcelo" wrote:

Hi GMed,

try to use the TOOLS | CHANGES CONTROL

Hope this helps
regards from Brazil
Marcelo

"GMed" escreveu:

Is there anyway to set my font color to a specific color as I type? I want
to make changes to cells and see what cells have been changed by the color of
the font.
I don't like the way the "track changes highlighting" prints out. Thanks!


  #4  
Old June 19th, 2006, 08:20 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default type in a different color

Sorry Gmed, as my excel is in portuguese, I'm just try to translate it, the
correct is

TOOLS | TRACK CHANGES

Hope this helps
regards from Brazil
Marcelo

"GMed" escreveu:

I don't see that in my tools menu, is it an add in feature? Thanks!

"Marcelo" wrote:

Hi GMed,

try to use the TOOLS | CHANGES CONTROL

Hope this helps
regards from Brazil
Marcelo

"GMed" escreveu:

Is there anyway to set my font color to a specific color as I type? I want
to make changes to cells and see what cells have been changed by the color of
the font.
I don't like the way the "track changes highlighting" prints out. Thanks!


  #5  
Old June 19th, 2006, 08:26 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default type in a different color

Not "as you type" but you can use event code to change the font color when you
hit the ENTER key

This code operates on A1:C100 cell range.

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("A1:C100")) Is Nothing Then
With Target
If .Value "" Then
Target.Font.ColorIndex = 3
End If
End With
End If
ws_exit:
Application.EnableEvents = True
End Sub

Right-click on sheet tab and "View Code".

Copy/Paste code into that sheet module.


Gord Dibben MS Excel MVP

On Mon, 19 Jun 2006 11:49:02 -0700, GMed wrote:

Is there anyway to set my font color to a specific color as I type? I want
to make changes to cells and see what cells have been changed by the color of
the font.
I don't like the way the "track changes highlighting" prints out. Thanks!


  #6  
Old June 19th, 2006, 08:32 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default type in a different color

, Oh! Thanks, that does work to identify the cells I changed, but it prints
out rather messy, so I'd rather track the changes by font color...

"Marcelo" wrote:

Sorry Gmed, as my excel is in portuguese, I'm just try to translate it, the
correct is

TOOLS | TRACK CHANGES

Hope this helps
regards from Brazil
Marcelo

"GMed" escreveu:

I don't see that in my tools menu, is it an add in feature? Thanks!

"Marcelo" wrote:

Hi GMed,

try to use the TOOLS | CHANGES CONTROL

Hope this helps
regards from Brazil
Marcelo

"GMed" escreveu:

Is there anyway to set my font color to a specific color as I type? I want
to make changes to cells and see what cells have been changed by the color of
the font.
I don't like the way the "track changes highlighting" prints out. Thanks!


  #7  
Old June 20th, 2006, 07:22 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default type in a different color

THANKS! that is just what I wanted.

"Gord Dibben" wrote:

Not "as you type" but you can use event code to change the font color when you
hit the ENTER key

This code operates on A1:C100 cell range.

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("A1:C100")) Is Nothing Then
With Target
If .Value "" Then
Target.Font.ColorIndex = 3
End If
End With
End If
ws_exit:
Application.EnableEvents = True
End Sub

Right-click on sheet tab and "View Code".

Copy/Paste code into that sheet module.


Gord Dibben MS Excel MVP

On Mon, 19 Jun 2006 11:49:02 -0700, GMed wrote:

Is there anyway to set my font color to a specific color as I type? I want
to make changes to cells and see what cells have been changed by the color of
the font.
I don't like the way the "track changes highlighting" prints out. Thanks!



  #8  
Old June 20th, 2006, 08:09 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default type in a different color


Thank you for the feedback.

Gord


On Tue, 20 Jun 2006 11:22:02 -0700, GMed wrote:

THANKS! that is just what I wanted.

"Gord Dibben" wrote:

Not "as you type" but you can use event code to change the font color when you
hit the ENTER key

This code operates on A1:C100 cell range.

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("A1:C100")) Is Nothing Then
With Target
If .Value "" Then
Target.Font.ColorIndex = 3
End If
End With
End If
ws_exit:
Application.EnableEvents = True
End Sub

Right-click on sheet tab and "View Code".

Copy/Paste code into that sheet module.


Gord Dibben MS Excel MVP

On Mon, 19 Jun 2006 11:49:02 -0700, GMed wrote:

Is there anyway to set my font color to a specific color as I type? I want
to make changes to cells and see what cells have been changed by the color of
the font.
I don't like the way the "track changes highlighting" prints out. Thanks!




Gord Dibben MS Excel MVP
  #9  
Old January 26th, 2010, 01:01 AM posted to microsoft.public.excel.misc
Susan
external usenet poster
 
Posts: 651
Default type in a different color

Gord:

The code worked for me, but when I emailed the spreadsheet out and the
person who I sent it to made changes to the spreadsheet, it didn't capture
their changes in the "other color". Is there something else I need to do to
the formula to make it work when I am sending it out?

"Gord Dibben" wrote:

Not "as you type" but you can use event code to change the font color when you
hit the ENTER key

This code operates on A1:C100 cell range.

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("A1:C100")) Is Nothing Then
With Target
If .Value "" Then
Target.Font.ColorIndex = 3
End If
End With
End If
ws_exit:
Application.EnableEvents = True
End Sub

Right-click on sheet tab and "View Code".

Copy/Paste code into that sheet module.


Gord Dibben MS Excel MVP

On Mon, 19 Jun 2006 11:49:02 -0700, GMed wrote:

Is there anyway to set my font color to a specific color as I type? I want
to make changes to cells and see what cells have been changed by the color of
the font.
I don't like the way the "track changes highlighting" prints out. Thanks!



  #10  
Old January 26th, 2010, 01:58 AM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 20,252
Default type in a different color

The other user must have macros enabled to start.

Is there any other code in your workbook that may have disabled events?


Gord

On Mon, 25 Jan 2010 16:01:01 -0800, Susan
wrote:

Gord:

The code worked for me, but when I emailed the spreadsheet out and the
person who I sent it to made changes to the spreadsheet, it didn't capture
their changes in the "other color". Is there something else I need to do to
the formula to make it work when I am sending it out?

"Gord Dibben" wrote:

Not "as you type" but you can use event code to change the font color when you
hit the ENTER key

This code operates on A1:C100 cell range.

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("A1:C100")) Is Nothing Then
With Target
If .Value "" Then
Target.Font.ColorIndex = 3
End If
End With
End If
ws_exit:
Application.EnableEvents = True
End Sub

Right-click on sheet tab and "View Code".

Copy/Paste code into that sheet module.


Gord Dibben MS Excel MVP

On Mon, 19 Jun 2006 11:49:02 -0700, GMed wrote:

Is there anyway to set my font color to a specific color as I type? I want
to make changes to cells and see what cells have been changed by the color of
the font.
I don't like the way the "track changes highlighting" prints out. Thanks!




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mozilla Firefox problem Please Hejp shen923 Publisher 8 May 16th, 2006 08:16 AM
Hardwired Colors vs. Color Schemes Scott Meyers Powerpoint 2 January 4th, 2006 04:53 PM
Add New Field to DB Karen Database Design 7 October 19th, 2005 08:03 PM
systemcolor Amorax Using Forms 1 December 31st, 2004 04:39 PM
Change Letter Color when I type the letter Anne Fu Worksheet Functions 2 May 18th, 2004 05:17 PM


All times are GMT +1. The time now is 08:57 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.