Command Buttons for Fill Colour and Font Colour

Hi all,

I am really struggling trying to put a template together and would be very grateful for some help.

Please see attachment.

I want to use the four command buttons as follows:

When a user selects any range (one or more cells) and then clicks a Fill Colour or Font Colour command button, I want all the rows for the selected range, from column A to column AC, to be highlighted accordingly – that is, fill colour or font colour. The command buttons must toggle – to (1) colour and (2) remove colour.

Recalculate sheet only when there is a change in column X.

Row 1 has the command buttons, and row 2 is the header row.

Appreciate your help.

Thank you.
Gos-C