Can you change a cell color just by clicking it?

[donutboy]

I would like to turn a group of cells red or green just by using mouse clicks. Click one time and it turns red, click it again it turns green. Is that possible?


If that is not possible I would like to turn them colors by entering "y" for yes = green and "n" for no = red.



Thanks you guys/gals

 

[Duvlinia]

Hi everyone. Brand new to this forum.

 

[Duvlinia]

Hi everyone. Brand new to this forum (as you can see from previous post).

I am looking to change the colour of a cell based on another cell. In this instance.... G6 would change to whatever corresponding colour was in B6 and in the next row... f7 would change to whatever colour was in b7. And double click again to get it blank. Is that possible?

I would say I would have to write code for each colour. But would I be able to set that code for a range in a single row only?

Thanks in advance.
Duv

 

[Tom.Jones]

This is an old thread.
We recommend creating a new thread to ask your own question.