Locate Blue Cells in Col F then CHANGE value to 0% using VBA

[ChrisOK]

Need VBA code to start with row 5 and look through COL F for any blue cells, IF=BLUE change the percent to 0% for that cell.
The RGB color code for this particular shade of blue is: Red 153, Green 204, Blue 255.

 

[vds1]

Try This..

    With Application.FindFormat
        .Clear
        .Interior.Pattern = xlSolid
        .Interior .Color = 16764057
        .Locked = True
    End With
    Range("F5:F" & Range("F" & Rows.Count).End(xlUp).Row).Replace What:="", _
        Replacement:="0%", LookAt:=xlWhole, SearchFormat:=True
    Application.FindFormat.Clear

 

[ChrisOK]

FANTASTIC! Works like a charm, *with one edit needed here: .Interior .Color = 16764057
There's a extra space between 'Interior' and 'Color' that needed removed -- just FYI for anyone else who might find this code helpful for their use...
Thanks vds1 ! I've clicked *LIKE* to make sure you got 'kudos'...
C.