Hi all,
I have revenue values per month for X number of months with Month along the X-axis and . How do I conditionally format Red-To-Green/Lowest-To-Maximum the values across with the same color formatting starting anew by each item along the Y-axis? The equivalent would be Excel's Green-Yellow-Red color scale under Conditional Formatting.
For example:
PartnerJanuaryFebruaryMarchYouTube50150100Twitch1005075
Alternatively, I'd be okay (and probably prefer) with month-to-month change colors of red/green to represent month-over-month delta compared with the previous month. Example below:
PartnerJanuaryFebruaryMarchYouTube50150100Twitch1005075Thanks for the assist. Unfortunately, this doesn't quite get me there. I know how to conditionally format metrics/dimensions, but what I don't know how to do is re-apply the color scale automatically per row, rather than all rows combined. Not all rows' values are created equal, so if the scale of Row 1 is 1-1,000,000, it should apply the chosen color scale at that scale of difference, while Row 2 being 1-5,000 should have the same color scale applied to it, but at the 5,000 scale instead of 1,000,000. IE: Re-apply the same color scale conditional formatting to each row independently of all other rows related to the specific dimension/metric.
Example:
Partner
January
February
March
YouTube50150100Twitch100,00050,00075,000
