Hi,

Can anyone help?

I'm a novice to VBA but, after many years resisting, I have finally bitten the bullet.

I'm trying to automate some student records I have to administer.

Some of my fields (cells) contain three colours - black for the original criterion, red if work is needed, green if the skill is already acquired.

I have transferred all my data using a macro from 120 files into one unreadable (but well-mapped) spreadsheet.

When I try to call the data using VBA into a spreadsheet resembling the old form, I get the data but it's all in black.

Any advice would be appreciated.
Thanks....