I wish to write a code by which the rectangle shapes on sheet1 changes the color to red based on Sheet2!A2.
If A2 is 0, the color of shape 2 should be white and if A2 is 1, then color should be red and so on.
Can someone help ?
Thanks,
I wish to write a code by which the rectangle shapes on sheet1 changes the color to red based on Sheet2!A2.
If A2 is 0, the color of shape 2 should be white and if A2 is 1, then color should be red and so on.
Can someone help ?
Thanks,
The scheme colors aren't the same as the color index colors - but you can play with it
Try this in the Sheet2 module:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thanks.
Can you help me understanding this code please?
Last edited by aleenkhan; 09-14-2017 at 02:45 AM.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks