| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get an autoshape to have same format as its linked cell?
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I add a autoshape such as a diagonal line to a cell | Excel Discussion (Misc queries) | |||
| Conditional format not carrying over from linked cell | Excel Discussion (Misc queries) | |||
| format a linked cell | Excel Worksheet Functions | |||
| Format Autoshape Contents | Excel Discussion (Misc queries) | |||
| preserving cell format between linked documents | Excel Discussion (Misc queries) | |||
Threaded Mode
