Command Buttons for Fill Colour and Font Colour

romperstomper, the code works on one row only - ever if more than one row is selected.

teylyn, yes, I will be summing values in column X if the fill colour of the row is yellow.

How can I have the code highlight all the rows in the selection?

Thanks,
Gos-C