Forum Discussion

narasimhuluk's avatar
narasimhuluk
Frequent Visitor
7 years ago
Solved

Percentage column with different background colours conditionally

Hi Folks    i have column like  column 1   80% 98% 99% 99.99% 100%   i want to show background colour conditionallay  say  <98.00% -red colour  >98.00 - >99.99 -amber  >99.99 green  i ...
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi narasimhuluk,

 

You have to try with like this.

 

For 80% --> use .80

similarly, 98% --> .98

 

This would works.

 

Regards,

Pradeep

  • narasimhuluk's avatar
    narasimhuluk
    Frequent Visitor
    7 years ago

    its not working for percentage values 

    i have values like 

    Column1     column 2

    98.00%         98

    99.00%         99

    99.99%         99.99

    100.00%         100

    i tried with decimal values but its not wotking for  column 1 yes it is working for numbers column 2

    i want to set back ground colour conditionaly for column 1