Excel VB updating function 1

[droberts200401]

Hello All,

New to VB and require some help please.

I'm in process of creating a tracking sheet for a project. I have a Top Sheet which gives you a snap shot of the entire project and if milestones are -

On Target (green)
Looking unstable (amber)
Will miss target (red)

The Top Sheet is fed by four other wookbooks (feeders) e.g Finance, Technical, Systems & Processes and HR.

What I would like to do and so far failed to achieve is for the Feeder sheets to transfer their information into the Top Sheet. For example, Finance overall is Green in the Feeder Sheet and so needs to be shown automatically as Green in the Top Sheet.

Hope I have made this clear! Not sure whether to do a Drop Down box or not as I cannot find out how to dipslay colours in a Drop Down box.

Regards

Dave

 

[Chance1234]

not to clear what you are trying to do, have you looked at conditional formating ? its under the format menu in excel

Chance,

Filmmaker,gentleman and --. -- - ..- .. -..-

http://WWW.5YLAC.S5.COM

,

http://WWW.HOWTOBESPOOKY.CO.UK

 

[000Steve000]

Further to the above. Try making the colour change in the underlying sheets a function of the value in the cell eg 1= Red 2 = Amber 3 = Green. Then set up the colours using conditional formatting. Then copy and paste/link the cells into the master sheet and conditionally format the cells in the same way. Then any change to the number in the underlying sheets will change the colours in both sheets.
I once did a Balanced Scorecard that did a similar thing. The limitation of Conditional formatting is the limit to 3 conditions (3 colours). Any more and you will need a macro to do the colour coding.

Hope this helps.