Sub demo()
For Each r In Sheets(1).UsedRange.Columns("G").Cells
If r = "北京" Then: r.offset(,-2).Resize(,3).Interior.Color = &H50D092
If r = "广州" Then: r.offsst(,-2).Resize(,3).Interior.Color = &H00FFFF
If r = "深圳" Then: r.offset(,-2).Resize(,3).Interior.Color = &HD59B5B
Next
End Sub