Bright01
asked on
Macro to change color
EE Pros,
I'm in need for some help with a macro.
I need a macro that changes the color in the Cell from blank to white (vblack) when you double click on the cell or merged cells. It needs to only be active for a specific range of cells.
Help would be appreciated.
B.
Color-change.xlsx
I'm in need for some help with a macro.
I need a macro that changes the color in the Cell from blank to white (vblack) when you double click on the cell or merged cells. It needs to only be active for a specific range of cells.
Help would be appreciated.
B.
Color-change.xlsx
ASKER
Thanks Wayne! No....black to blank. or blank to black.
B.
B.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Quick, accurate, works! Thank you!
B.
B.
You might have been able to use Conditional Formatting rather than using the Double Click.
CF allows you to apply formatting based on a condition in the specific cell or elsewhere.
CF allows you to apply formatting based on a condition in the specific cell or elsewhere.
ASKER
Rob,
Thanks for the comment. I am using Condition formatting but need to be able to rapidly change cells without a formula. The double click makes a good solution.
Again thank you,
B.
Thanks for the comment. I am using Condition formatting but need to be able to rapidly change cells without a formula. The double click makes a good solution.
Again thank you,
B.
Color-change.xlsm