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 cheched contional formating with 'Rules ' is giving only for numbers not for percentages and it is taking lowest and highest vaues but i want accurally 

column 2

98

99

99.99

100

contional formating with 'Rules ' is giving only for for column2 values but not column 1 percentage values 

please guide me to allocate a background colour accuraly based on conditions like conditional formating rules ....

Tips and Tricks

3 Replies

  • 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