This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
My boss has asked me to automate an excel file he originally composed manually. This includes percentage differences, negative and positive indicators (color correlated) , totals, grand totals, and percent differences from when this first file was composed.
I've managed to accurately generate the aging buckets totals and grand totals. But when generating the percentages and their associated indicators + the layout of the whole thing.....Well....It's become very difficult to emulate these lingering portions. Here is a small example of what I'm trying to obtain....
This can definitely be done. Did you know that you can copy and paste special characters from the Character Map into the Formula Tool?
You'll notice that the bottom formula is converting the numbers that represent my percentages over to a report ready format. This has to be done, while maintaining the original column so I have something to reference in the table tool when applying conditional formatting.
Now we can connect to the table tool and setup our formatting:
The output looks like this:
Attached is a sample workflow for you to try out.
If this solves the problem please mark answer as correct, if not let me know!
Thanks Phil @Maskell_Rascal , this is very cool! I was wondering in this case, how can I obtain the % differences from each sectors "improvement" week over week? And also , how can I get the percentage difference from Day 1, when the file was originated? I've tried several calculations but all end up failing.