Re: Change Font Color Across Sheets
Hopefully this might be able to help you. Its one of the sub files that reads from the main workbook. The information pulled from the main workbook is just a direct copy i.e NPower is entered into a particular cell on the main workbook and automatically shows NPower in the corresponding cell in Forum.xls.
From the attached file you can se the 3 colour changes we use for this sheet. We would love to be able to make the colour changes (currently we change the colour of the font but are happy to change the cell colour if its easier) in the main file and have it update the sub sheets like the one attached.
I hope this helps and thanks for the help.