software

I have a series of autoshapes which contain values from various cells.
I want to set the background colour of the autoshape based on the value
within it.
e.g. If the cell from which the value is retrieved contains quot;Rquot;, the
autoshape would be coloured red.
Any ideas?--
tonywig
------------------------------------------------------------------------
tonywig's Profile: www.excelforum.com/member.php...oamp;userid=18985
View this thread: www.excelforum.com/showthread...hreadid=534050
If you have a look at the graphics macro on my download page, you will
get an idea of how to manipulate the colours of autoshapes.--
mrice

Reserach Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: www.excelforum.com/member.php...oamp;userid=10931
View this thread: www.excelforum.com/showthread...hreadid=534050