[VBA]If Not IsEmpty(Dec_TX) And IsEmpty(Dec_CC) And ActiveSheet.Cells(21 + i, 2).Interior.Color = RGB(197, 217, 241) Then ' if TX is populated and CC is blank
[/VBA]