Aug 25, 2005 #1 Leclerc Chemical Aug 22, 2002 73 Is it possible to change the colour of an autoshape or fill of an autoshape, depending upon the value in another cell?
Is it possible to change the colour of an autoshape or fill of an autoshape, depending upon the value in another cell?
Aug 25, 2005 #2 pmover Mechanical Sep 7, 2001 1,507 yes, but with limitations, which are: 1) accomplished using vba code. 2) value in cell is a valid color. good luck! -pmover Upvote 0 Downvote
yes, but with limitations, which are: 1) accomplished using vba code. 2) value in cell is a valid color. good luck! -pmover
Aug 30, 2005 Thread starter #3 Leclerc Chemical Aug 22, 2002 73 thank you Pmover. unfortunately, just as I suspected. Upvote 0 Downvote
Sep 3, 2005 #4 johnwm Computer Sep 26, 2002 806 You could always use Select Case in your macro - you can then use any values to set any colours Good Luck johnwm ________________________________________________________ To get the best from these forums read faq731-376 before posting Steam Engine enthusiasts: http://www.essexsteam.co.uk Upvote 0 Downvote
You could always use Select Case in your macro - you can then use any values to set any colours Good Luck johnwm ________________________________________________________ To get the best from these forums read faq731-376 before posting Steam Engine enthusiasts: http://www.essexsteam.co.uk
