VBA color rows based on criterion

[jakobt]

In column K there are comments. In the comment if the word "CTAX" appear, I would like to write the word Reconciled in column Q. And mark the cells from column B to K Blue in the same row.

 

[Fluff]

Misread OP.

 

[steve the fish]

Its possible but do you really want to use comments to control the use of a spreadsheet? Thats not nice design in my eyes.

 

[Fluff]

I agree with Steve, that controlling a sheet via comments is not a good way to work.
However try

Sub reconciled()
   Dim Cl As Range

   For Each Cl In Range("K2", Range("K" & Rows.Count).End(xlUp)).SpecialCells(xlComments)
      If InStr(1, Cl.Comment.Text, "ctax", 1) > 0 Then
         Cl.Offset(, 6).Value = "Reconciled"
         Cl.Offset(, -9).Resize(, 10).Interior.Color = vbBlue
      End If
   Next Cl
End Sub