Thanks for the tip Roy.

I considered trying to code it that way but I couldn't figure out how to only colour the cell when the checkbox is ticked from a WorkSheet event. It would be pretty straightforward to colour the cell depending on whether any text was entered using conditional formatting outside of VBA, but I guess it brings me back to my original question - how do I get the cell to change colours only when the checkbox is ticked?