november678x wrote:

Thanks for the reply. I pasted this into the sheet code but the
background color wont change when I enter the codes. Does the version
of excel matter? Or is there another variation of this I can try?

i wrote:

If rng.Value = "POI" Then
rng.Interior.ColorIndex = 2
ElseIf rng.Value = "KFI" Then
rng.Font.ColorIndex = 3

but of course shoul be Interior.ColorIndex (not Font)