You could go either way to achieve your end result.
You may want to try a VBA code written by one of our Gurus (https://www.excelforum.com/members/9307.html ) - Andy Pope: Set Cell Color Based On CheckBox State | answer #4.
Which uses an ActiveX Control checkbox and the following code on the sheet
Or you could try using a Form Control checkbox which is linked to a cell (in this case A1), and use Conditional Formatting - Format only cells that contain: Cell Value > Equal to > =TRUE
- Format: Font > "Pick a color" | Fill > "Pick same color as font"
See attachment
Bookmarks