I have a spreadsheet that I want to make the value turn red when it meets certain criteria
This actually changes the format of the particular cell with condition A
Condition A
If .Value “?whatever?” Then
.Font.ColorIndex = 3
I can turn the formatting back to black (Default - automatic) once the cell is “null” using condition B
Condition B
If .Value = “” Then
.Font.ColorIndex = 1
Once condition A has been met and the formatting has been changed
If the user deletes the contents of the cell with the delete key it works as needed
If the user backspaces the value from the cell and moves from the cell and then back again it works as needed
But if the user backspaces the value from the cell and retypes a value without leaving the cell the code never see the cell as null.
Is there a way around this or is this a black hole?
Vinnie
This actually changes the format of the particular cell with condition A
Condition A
If .Value “?whatever?” Then
.Font.ColorIndex = 3
I can turn the formatting back to black (Default - automatic) once the cell is “null” using condition B
Condition B
If .Value = “” Then
.Font.ColorIndex = 1
Once condition A has been met and the formatting has been changed
If the user deletes the contents of the cell with the delete key it works as needed
If the user backspaces the value from the cell and moves from the cell and then back again it works as needed
But if the user backspaces the value from the cell and retypes a value without leaving the cell the code never see the cell as null.
Is there a way around this or is this a black hole?
Vinnie