Code Changing The Color Property of The Wrong Cells

[Ark68]

I have this code:

If .Range("K" & t) = "AUTO" Then
                .Range("K" & t) = Format(Application.VLookup(.Range("A" & t), rcore, 54, False), "h:mmA/P")
                With .Range("K" & t)
                    .FormatConditions.Delete
                    .Font.Color = vbWhite
                    .Interior.Color = RGB(128, 128, 128)
                End With
             End If
             
             If .Range("L" & t) = "AUTO" Then
                .Range("L" & t) = Format(Application.VLookup(.Range("A" & t), rcore, 57, False), "h:mmA/P")
                With .Range("L" & t)
                    .FormatConditions.Delete
                    .Font.Color = vbWhite
                    .Interior.Color = RGB(128, 128, 128)
                End With
             End If

It is intended to change the font colour to white when the cell = "AUTO". It does, but it also changes the contents of the cell (like NA, and NR) to white when they aren't equal to AUTO.

I'm not sure where I messed up.

 

[p45cal]

the line:

.Range("K" & t) = Format(...
should update a cell which had AUTO in it to something which probably isn't AUTO. If you want to retain AUTO in the cell, comment-out/delete this line and the similar one below it.
</pre>

 

[Ark68]

Thanks p45cal ... that's what was needed.
Thanks so much for your help.

Jenn