Hey, I have over than 10 years of experience developing, complicated Macro for my clients,
In my last full time job, I've developed a Macro that takes as Input Reports and based on them, run some few calculation, and automatically in few seconds draw some compelling charts as well as KPIs values.
It was for a social marketing agency, as you may surely know, advertisers need some compelling metrics in order to decide if their campaigns are either successful or not.
As an example of those Metrics, there's the conversion rate as well as the lifetime average billing of each clients.
What's more amazing is that we've been including colors, to final results so Macro make more easier extracting great insights.
As an example we've been having a specific cell in the Main Dashboard, where the user can specify a specific Value of the conversion rate, and based on this Values, the results sheet cells can be either colored with Green and Red.
I think that that's what you may need, with some slight modifications.
I am happy to start the work.
Let chat more,
Yasser.