"Conditional formatting" is only possible with restrictions

[SeApel2020]

Hi, actually I'm trying to create a new rule for coloring cells on my excel sheet. My problem is that I can't choose any type of rules (see screenshot). How can I expand the window (as you can see on the second screenshot) to create my own individual rules based i.e. on different numerical values? 

Thank you very much and kind regards

Sebastian 

[#2]

@SeApel2020 

Sehe Bild.
Dort können Sie Ihre ansätze an Formeln eingeben um die Bedingtwe Formatierung zu aktivieren.

Falls Ihnen die anrtwort nicht zur lösung geführt hat, bitte um kurze rückmeldung.

Wenn doch, bitte als Richtige Antwort Markieren, sa das auch andere Benutzer informiert werden können.

Nikolino
Ich weis das ich nichts weis (Sokrates)

[#3]

@SeApel2020  This appears to be a Mac questions.  Maybe @mathetes  could help?

[#4]

You are absolutely right, I missed it ... thanks



Nikolino
I know I don't know anything (Socrates)

[#5 · Accepted solution]

@SeApel2020 

I do have a Mac, but not in German...when I open the Conditional Formatting dialog box I get this set of choices first. What you seem to be looking for is the last of the options, here called "Classic"

After selecting "Classsic" I am directed to this screen where I can choose (again the last of a set of drop down choices, to "Use a formula..."

Are you not seeing comparable screens in the German edition?

[#6]

@mathetes Thank you very much! The German version works similarly :)