After selecting a cell (or range) i wish to be able to 'click' on another
cell , say A1, and the formatting of the previously selected range to be
changed, such as the interior color. The idea is to speed up / automate the
formating of the selected range. Any ideas?