conditional formatting of autoshapes

[Leclerc]

Is it possible to change the colour of an autoshape or fill of an autoshape, depending upon the value in another cell?

 

[pmover]

yes, but with limitations, which are:

1) accomplished using vba code.
2) value in cell is a valid color.

good luck!
-pmover

 

[Leclerc]

thank you Pmover.
unfortunately, just as I suspected.

 

[johnwm]

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