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?
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?
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.
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.
If you need more than that, give us a little more detail and we can help further.Please Login or Register to view this content.
BSB
@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.
@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
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.
Did you try the proposal in post #3 above?
BSB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks