Change the Color of Historical Data

3 posts / 0 new
Log in or register to post comments.
Last post
5 years ago
#1
X 0
Change the Color of Historical Data

How does one change the color of historical data...for example, how can I change the color of the text circled in red..see the picture below:

I have tried all kinds of things and nothing seems to work.
5 years ago
James Longden A+ 87

Hi William,

This is just normal conditional formatting, so if you go to HOME / CONDITIONAL FORMATTING / MANAGE RULE and remove the applicable rule, this will make the entire row blue assumption cells.

However, the main thing to note is that these are inactive assumptions, so not having any impact on the calculated cost of goods sold - these values are actually coming through from the historical income statement data. As such, I would be wary when removing this conditional formatting as it might give the impression that those assumptions are driving the values below, which they won't be.

Cheers. J.

5 years ago
Michael Hutchens A+ 162

Hi William,

You can check out the Inactive Assumptions guideline and example here: www.modano.com/guidelines/modano/assumptions/inactive_assumptions

M.