IF cell is BLUE (AND) is value is GREATER THAN 0% then make font bold red (VBA)

[ChrisOK]

Need VBA that will scan through COL E locating ONLY blue cells that have a value GREATER than 0%. If true, change font to RED BOLD.

The color blue being used is: Red 153, Green 204, Blue 255

 

[akmatz]

Try this on a COPY of your data, not the original.
Sub ChrisOK()
Range("e2").Select
Do Until ActiveCell.Value = ""
If Selection.Interior.Color = 16764057 And ActiveCell.Value > 0 Then
Selection.Font.Bold = True
With Selection.Font
.Color = -16776961
.TintAndShade = 0
End With
End If
ActiveCell.Offset(1, 0).Select
Loop
End Sub

 

[ChrisOK]

Wow! It works perfectly! Thanks akmatz! ( I clicked "LIKE" so you'll get some kudos ) - Thanks again, C.

 

[akmatz]

You are very welcome and "Thank you" as well.