I want to have conditional formatting in my pivot table. The column I want to have the color rules to is 'Month_Value'. Each row will be a different condition based on the metric.
I tried using HTML Markup with the pivot table but nothing appears at all. I am not sure if the HTML Markup is available on the pivot table chart. I also tried creating another column with 'Goal' or 'No Goal' and apply color rules to the entire row based on that column. The color rule only apply to the Goal or No Goal column instead of the entire row. Is there a workaround to apply conditional formatting to this pivot table?
