How can we get multiple colour heat map with input box values (esp in Pivot tables)
Can you please help me to create Pivot table (Heat Map) with input box values.
Check below Pivot table:
vGreen should be >=0.8 vBlue should be >=0.5 <0.8 vRed should <0.5
Question: I've created three variables (vGreen, vBlue and vRed) and assigned them to input box to change the numbers manually. How can I change colours in Pivot table if numbers entered manually in Input Box.