Forum Discussion
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...
- 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.
Not sure why it doesnt do that in my file 🙁
