Press button to change cell background

[Civion]

Hi all, I don't know if this is possible or not, but if it is I could really do with some pointers on how I can get this to work

The idea is that if a user presses the blue button the background in the coloured cells changes to blue, if red button pressed then the fill colour changes to red

Have attached picture to show a brief screenshot

Capture.JPG

Any advice on the best way to achieve this (if possible) is much appreciated, or alternatively let me know if it is not possible.

[davesexcel]

You can use the macro recorder to turn the cells red, then use it again to turn the cells blue.
Assign the appropriate macro to each of the buttons.

[Roel Jongman]

Some pointers

by using "Selection" you can tell Excel VBA to use the selected cells for the next command
with the RGB function you can set any color you need.

Please Login or Register  to view this content.

[Civion]

So it is possible ? that is excellent news, thanks very much.

Guess I have best start reading up on macros, I never needed/used them before !

[davesexcel]

Here is a simple clip on recording a macro

Record a macro