Hi Bob,
I implemented this, thought it would do the trick. But still hitting a brick wall.
I have had to change my numberformat for the cells to Fraction - "??/??" to accommodate a few values like 9/10, 11/12.
Due to this format style when I use the line of code
[VBA]If Cells(i, "k").Text Like "*?/?" Then[/VBA]
It does not find any of the fractional values of single values fractions like 1/8 because it is formatted as "??/??"
Any other suggestions?
I am telling you, the 80/20 rule is pushing my buttons right now....

[VBA]
Sub testk()
Dim i As Integer
Dim lrow As Long
Dim ws As Worksheet
Set ws = ActiveSheet
lrow = Cells(Rows.Count, "A").End(xlUp).Row
For i = 1 To 20
If Cells(i, "k").Text Like "*?/?" Then
Cells(i, "k").NumberFormat = "General"
'Cells(i, "k").Interior.Color = vbYellow
End If
Next i
End Sub
[/VBA]