1 2 Previous Next 16 Replies Latest reply on Oct 20, 2016 2:09 PM by satish.pandey

    How to highlight data in different background based on given range

    satish.pandey

      Hi Expert,

       

      I have a requirement where i need show the threshold based on total hours for each resource.

      For each resource i am showing percent for each task and summing up using Column Totals to top.

      Now i have to highlight total in different color if percentage is more than 120 in yellow and percentage is less than 100 then red color.

      color3.png

       

      I tried using the solution given by tableau but it didn't work for me as i have to apply conditional formatting based on the Total percentage

       

      I have attached the screenshot for my requirement. Bold values should be highlighted with different background.

       

      Can anyone please help ?

       

      Thanks

        1 2 Previous Next