Forum Discussion

Koalafied's avatar
Koalafied
Copper Contributor
May 22, 2023

How to add more than 3 col

Hello! I have a table where I want to put more emphasize on the values by highlighting them with colours once they reach a certain value. I want to put it into six categories: 95-100% 90-95% 85...
  • NikolinoDE's avatar
    NikolinoDE
    May 24, 2023
    As far as I can see from the picture, they work in German. this means that the formulas do not correspond to the language.
    Excel has different formula names for the same formula depending on the country.

    Here are the formulas translated into German:
    Für die Kategorie 95-100%: =UND($A1>=0,95;$A1<=1)
    Für die Kategorie 90-95%: =UND($A1>=0,9;$A1<0,95)
    Für die Kategorie 85-90%: =UND($A1>=0,85;$A1<0,9)
    Für die Kategorie 80-85%: =UND($A1>=0,8;$A1<0,85)
    Für die Kategorie 75-80%: =UND($A1>=0,75;$A1<0,8)
    Für die Kategorie <75%: =$A1<0,75

    The file I added doesn't work?
    If yes, can't you copy the rules from the example file?
    Additional information such as Excel version, operating system, storage medium, etc. would also help if this is not the problem.

Resources