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.



      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 ?



        1 2 Previous Next