Results 1 to 8 of 8

VBA: Script that changes new text to another color

Threaded View

  1. #1
    Registered User
    Join Date
    02-25-2014
    Location
    NJ, US
    MS-Off Ver
    Excel 2010
    Posts
    5

    VBA: Script that changes new text to another color

    Hello, this may be impossible, but I need a script that will change the color of new text entered in a cell. What I have right now changes the whole text color in the cell, I only need the specific text that was modified. This is what I have (the code was found in this forum by User: Palmetto) Any ideas?

    Sub Worksheet_Change(ByVal Target As Range)
    
        If Not Intersect(Target, Range("H8:L300")) Is Nothing Then
            If Target.Font.ColorIndex = 5 Then
                Target.Font.ColorIndex = 1
            Else
                Target.Font.ColorIndex = 5
            End If
        End If
        
    End Sub
    Last edited by alansidman; 02-26-2014 at 11:53 AM. Reason: Code tags added

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 12-29-2013, 11:41 PM
  2. script to write 1's and zero's for cell color
    By NPeters in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-07-2010, 01:52 PM
  3. VBA Script for Onclick Color Formatting
    By Solar in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-02-2009, 01:46 PM
  4. Script that edits the text printed on the button that runs the script
    By petalred in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2008, 02:41 PM
  5. [SOLVED] Cell Fill Color:VBA script
    By marypulliam@cox.net in forum Excel General
    Replies: 1
    Last Post: 06-27-2006, 10:00 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1