0

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:

How it looks like ath the moment

Error:

enter image description here

Formula in use

Format-Manager

Improve this question
11
  • what error do you get. That formula should work. Commented Aug 23, 2021 at 21:50
  • This is the error message filestore.community.support.microsoft.com/api/images/… Commented Aug 23, 2021 at 21:52
  • 1
    Does your local settings use ; instead of ,? Commented Aug 23, 2021 at 21:53
  • Changing , to ; indeed removed the error message, but it still doesn't highlight the columns. Commented Aug 23, 2021 at 21:56
  • can you edit your post to include a picture of the conditional format manager? Commented Aug 23, 2021 at 21:57

1 Answer 1

Reset to default
1

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

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

That actually worked out, such a simple solution. Thank you Mario!

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.