Remove conditional formatting on cell focus

L

lee2121

New member
Joined
Sep 10, 2018
Messages
11
Reaction score
0
Points
0
Excel Version(s)
Office 365
Is it possible to remove conditional formatting from a cell when the user enters the cell and changes the value?

Struggling to find a way of doing this any help would be appreciated.
 
Have you tried using the worksheet_change event on the sheet module ?
Code: 
Private Sub Worksheet_Change(ByVal Target As Range)
    Target.FormatConditions.Delete
End Sub
 
Tried and nothing happens, the conditional formatting remains in place. I'm trying to do this on a range of cells so whn any cell within the range is clicked in (focus) then the conditional fromatting for that cell only is cleared.

thanks.
 
... on a range of cells so whn any cell within the range is clicked in (focus) then the conditional fromatting for that cell only is cleared.
Click to expand...
This is not the same as your original request which indicated a change of value.
Without going into the guts of Excel you can't determine if the cell got focus by mouse click, enter key or tab key.
Maybe double clicking in a cell could be more applicable.
 
Thank you i have this working now as i actually need the formatting to be removed when the cell has been changed, your code works great.
 
You must log in or register to reply here.
Back
Top