How to get an autoshape to have same format as its linked cell?

F

Farmers Wife

I have a farm map made up of autoshapes for the paddocks. Each 'paddock' is
linked back to a cell which has the year that paddock last fertilised. I
want the autoshape to reflect the colour format of the cell ie . red for
2009, will change to say blue for 2010 etc. I have the autoshape linked so
it displays the year, but I can't get it to turn it the right colour. Help
please.
 
S

Shane Devenshire

Hi,

You will either have to manually change the color or write a VBA program to
do it.
You can speed up the process by selecting all the autoshapes you want to
format a particular color and then change the color once.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top