Forum Discussion

Klanger1969's avatar
Klanger1969
New Member
2 years ago
Solved

Conditonal formatting for percentages

Hello,   I am trying to conditionally format a percentage cell with the following rules:   Less than or equal to 50, the cell fills with red Greater than 50, the cell fills with green   I have...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    2 years ago

    Hi Klanger1969 

     

    This forum is for Power BI, but I can help anyway.

     

    You'll need to create 2 rules like so

     

     

    In that image my data is in the range B3:B8.  The rules state that if the value in B3 >= 0.5 then fill the cell red.  If the value in B3 > 0.5 then fill it green.

     

    CF rules are peculiar and hard to understand.  In this case my rules only seem to be checking the value in B3 but it actually applies to the whole data range B3:B8.

     

    Check this example Excel file and look at the rules I created.

     

    This blog might help too : Excel Conditional Formatting with a Formula

     

    regards

     

    Phil

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
2 years ago

Hi Klanger1969 

 

This forum is for Power BI, but I can help anyway.

 

You'll need to create 2 rules like so

 

 

In that image my data is in the range B3:B8.  The rules state that if the value in B3 >= 0.5 then fill the cell red.  If the value in B3 > 0.5 then fill it green.

 

CF rules are peculiar and hard to understand.  In this case my rules only seem to be checking the value in B3 but it actually applies to the whole data range B3:B8.

 

Check this example Excel file and look at the rules I created.

 

This blog might help too : Excel Conditional Formatting with a Formula

 

regards

 

Phil

Klanger1969's avatar
Klanger1969
New Member
2 years ago

Thanks Phil, I really appreciate the help despite me being in the wrong forum. Much appreciated.  I think I have it sorted out.

 

Regards,

 

Kent