Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Changing text colors for editing

If I have a previously saved worksheet that was saved with black text/font
and I want to keep track of cells I have edited and ones I need to edit by
having the ones I edit change to red, how can this be done without formatting
the cells as I go along or clicking the text color shortcut button for each
cell.

Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Changing text colors for editing

Private Sub WorkSheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Or IsEmpty(Target) Then Exit Sub
On Error GoTo ws_exit:
Application.EnableEvents = False
With Target
.Interior.ColorIndex = 3
End With
ws_exit:
Application.EnableEvents = True
End Sub

This is sheet event code. Right-click on the sheet tab and "View Code"

Copy/paste into that sheet module.

Alt + q to return to the Excel window.

When you edit a cell or enter data in a previously blank cell, background of
cell will turn red.


Gord Dibben MS Excel MVP

On Fri, 15 Aug 2008 14:30:04 -0700, Jalynno
wrote:

If I have a previously saved worksheet that was saved with black text/font
and I want to keep track of cells I have edited and ones I need to edit by
having the ones I edit change to red, how can this be done without formatting
the cells as I go along or clicking the text color shortcut button for each
cell.

Thanks.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Worksheet formatting (fill colors & text colors) disappeared sweettooth Excel Discussion (Misc queries) 2 June 24th 08 01:16 AM
Cell colors or text color changing when date in cell gets closer. Chase Excel Worksheet Functions 5 October 19th 06 08:57 AM
Changing colors? Lee Excel Discussion (Misc queries) 1 May 23rd 06 03:11 AM
Changing the colors Prado Excel Discussion (Misc queries) 2 March 3rd 05 07:41 PM
Changing colors davetteb Charts and Charting in Excel 1 February 18th 05 01:17 AM


All times are GMT +1. The time now is 09:54 AM.

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

About Us

"It's about Microsoft Excel"