It is not easy to find the exact solution but something similar to that can put more highlight on the same. I know this vbcode which can help you to get the results you are
expecting :
Code:
Private Sub Worksheet_Change (ByVal Target As Excel.Range)
If Not Intersect (Target, Range ("E4: E23")) Is Nothing Then
With Target
Select Case Target.Value
Case Is <0.5
. Interior.ColorIndex = 3
Case 0.5 To 0.79
. Interior.ColorIndex = 44
Case 0.8 To 0.99
. Interior.ColorIndex = 6
End Select
End With
End If
End Sub
Bookmarks