PDA

View Full Version : Model cell colours



dek
04-19-2015, 05:33 AM
Hi

I have developed a model over 10 sheets on a modular basis (assumption sheets, calculation sheets, output/report sheets).

I would like to implement a colour scheme (in a separate parameters sheet) by specifying the colour hex codes or equivalent for various cells in worksheets throughout the workbook:
- background cells = cell has white background fill
- assumptions / constant number values = cell has yellow background fill with black font
- contants text values = cell has white background fill with black font
- formulas = cell has white background fill with dark blue font
- outputs = cell has grey background fill with black font

Thanks in advance.