1 Reply Latest reply on Oct 29, 2012 11:50 AM by Deepak Gupta

    Linking Custom Properties to Excel

    Ian Hooton

      Hi,

       

      I am looking for a little help, not sure if what I would like to do canbe done.

       

      I have created custom properties that the user selects various departments and projects from (lists stored on a central excel file).

       

      What I would like to do is that when a drawing is created the existing custom properties are populated in to the drawing, this is easy, but what I would like to do is also have for example the department number appear on the drawing, but only by using a lookup on the department name. (each department has a different number, this is stored also on the central excel file). Then I would like depending on the department number colour a rectangle with a specific colour.

       

      I can do this no problem in excel using Vlookup and condition formating, but how can I translate this into a title block?