Excel Conditional Formatting Based on Another Cell

Question

I am trying to make an excel-sheet for the university, where every course for each season is listed, and whenever a grade in a specific range is entered, the corresponding rows (season, course, ECTS and Grade) needs to be highlighted in green.

The range is

1 ≤ Grade < 5

So far I have tried the following formula, which results in an error:

=AND($D2 >= 1, $D2 < 5)

This is how the sheet looks like:

Error:

Answer 1

If your excel is in German, have you tried using "UND" instead of "AND"?