Maintain or Lookup Formats
 

Hi - I'm trying to retain or obtain formats when performing a lookup
function. Essentially I have a list of Accounts and Accout Reps. Each Rep has
a different 'Status' for each account (Primary, Secondary, Tertiary). This
varies per account, so I've colour coded them Green, Yellow and Red. Now I
want a separate input sheet where I selcet the account from a drop-down menu
and see the list of Reps with the colour coding.

Thx