Double click to change cell color

**amein** · 04-08-2016, 03:29 AM

Hey guys,

Need help here to fix my code.. My objective to double click on cell and cell color will change to GREEN and insert RECEIVED text.
The problem is, I need to fix my code so make make it work with colored cell also instead WHITE cell only

EDIT: Colored cell come from conditional formatting. (Maybe this is culprit??)

Vy0ytIO.png

Please Login or Register  to view this content.

**antoka05** · 04-08-2016, 06:33 AM

Yes, the conditional formatting overwrites the color of the cell.

You could add a new conditional formatting with green color for cells with 'RECEIVED' text and use the code only to put 'RECEIVED'.

Regards,
Antonio

**amein** · 04-11-2016, 03:12 AM

Originally Posted by antoka05

Yes, the conditional formatting overwrites the color of the cell.

You could add a new conditional formatting with green color for cells with 'RECEIVED' text and use the code only to put 'RECEIVED'.

Regards,
Antonio

Hi Antonio,

Thank you for clarification. Can you help me to trim down the code with only "RECEIVED" text.