Someone yesterday kindly helped with a scenario where if i entered 1 in a cell it would turn yellow.
Is there a way that if i entered 1m for example it would turn yellow?
My current code is this:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count = 1 Then
Select Case Target
Target.Interior.ColorIndex = 6
Target.Interior.ColorIndex = 41
Target.Interior.ColorIndex = xlNone