+ Reply to Thread
Results 1 to 7 of 7

Formatting edited cells

  1. #1
    Registered User
    Join Date
    12-20-2021
    Location
    Cleveland, OH
    MS-Off Ver
    Office 365
    Posts
    5

    Question Formatting edited cells

    Oddly I can't find it with Google or searching here.

    How do you format a cell differently (let's say green background and bold text) when its value changes in any way?

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Formatting edited cells

    Not sure what you mean by "in any way". Consider using the Conditional Formatting feature.

    Excel Conditional Formatting intro

    Excel Conditional Formatting Examples
    Last edited by AlphaFrog; 12-24-2021 at 02:38 PM.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Formatting edited cells

    I also am not sure what "in any way" really means, but the below change event added to the worksheet module will literally make the cell green and bold text for ANY change, even if it's just selecting an empty cell and hitting the delete key.
    Please Login or Register  to view this content.
    If you need more than that, give us a little more detail and we can help further.

    BSB

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Formatting edited cells

    @BadlySpelledBuoy
    Just to be more specific, the Worksheet_Change event procedure only works for user manual changes to the worksheet and not a formula calculation change.

  5. #5
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Formatting edited cells

    @AlphaFrog
    Good point, well made.
    The brief was VERY vague so we'll just have to wait and see what OP comes back with.

    BSB

  6. #6
    Registered User
    Join Date
    12-20-2021
    Location
    Cleveland, OH
    MS-Off Ver
    Office 365
    Posts
    5

    Re: Formatting edited cells

    Meaning that if it's blank and I put in a non-blank value, OR if it's a non-blank value and I change it to another non-blank value, OR if it's a non-blank value and I change it to blank, I would like it to get highlighted. I'm looking for a way to visually keep track of which cells have been edited.

  7. #7
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Formatting edited cells

    Did you try the proposal in post #3 above?

    BSB

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 10-20-2020, 06:24 PM
  2. UDF seem to be calculating when non dependant cells are edited
    By Hayley_ in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-15-2015, 02:45 PM
  3. [SOLVED] Is it possible for cells to automatically date themselves when edited
    By kevwilsondj in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-18-2014, 04:00 PM
  4. Replies: 0
    Last Post: 07-19-2012, 07:31 AM
  5. conditional formatting if the user has edited the cell?
    By bauerbach in forum Excel General
    Replies: 2
    Last Post: 06-21-2012, 10:15 AM
  6. protecting cells/colums from being edited
    By euwest30 in forum Excel General
    Replies: 1
    Last Post: 08-30-2010, 01:29 AM
  7. [SOLVED] Locking edited cells
    By ANDREWA in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-27-2009, 03:47 AM

Tags for this Thread

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