In Excel Click check box = auto change row

[dannymking]

That was a wuss out if I ever saw one...

Recorded macros over bloat the code.. this can actually be done in one line.. but I'll show the possibilities

ActiveCell.EntireRow.Interior.Color = vbBlue
Range("A1").EntireRow.Interior.Color = vbBlue
Range("D5").EntireRow.Interior.Color = RGB(0,0,255)

All set the either the last selected cell or a direct range to blue interior