VBA for changing cell colour (individual and merged)

[Phenomi]

Hi I would like to change a cell color from no fill to green just be double clicking. I am able to do it with single cell but not in merged cells. What other formula must i add into my existing ones to apply to merged cells as well? Thanks!

Note: the double clicking should be able to reverse the colour change back to no fill.

[Crooza]

Remove this highlighted line and merged cells will work

Please Login or Register  to view this content.

[Phenomi]

Thank you it works!