Change colour of a cell when it's clicked, change when it's clicked again.

**Crispy85** · 09-16-2014, 09:35 AM

Dear guru's,

I would like to use your suggestions for the following.

I have a basic calendar from excel-template.
The macro should change the color of a cell to green when the content inside of that cell is clicked. When clicked again it should change the color of the cell to red. When another click is done it should format it to empty again.

So to get the idea the calender is marked.

My idea was to use hyperlinks in the cells to activate macro's. But i don't know if there are any easier examples.

Do you guys have any better suggestions?
Thanks a lot for your help,

Regards.
Crispy85

**nathansav** · 09-16-2014, 09:43 AM

Record yourself formatting the colours, then look at the code, thats the 1st bit done, then you can use an if statement based on what you have

so

Please Login or Register  to view this content.

Recording standard excel functions will give you a great insight into coding

**JOHN H. DAVIS** · 09-16-2014, 09:51 AM

Maybe:

Please Login or Register  to view this content.

**Crispy85** · 09-16-2014, 10:10 AM

Thanks for your help guys!! I'll work on it tonight!

Regards,
Crispy

**Crispy85** · 09-16-2014, 12:55 PM

Hi all,

I tried something with the help of you and internet.
Please find my workbook attached.

the workbook has 2 years (2014 & 2015).
The script works, but only for january 1st till january 11th.

In the year 2015 it doesn't work at all.
Can you see what i'm doing wrong in this code?

Thanks for all the help, i appreciate it.

Regards,
Crispy85