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:

This is the error message filestore.community.support.microsoft.com/api/images/… — Seven
– Seven, Commented Aug 23, 2021 at 21:52
Changing , to ; indeed removed the error message, but it still doesn't highlight the columns. — Seven
– Seven, Commented Aug 23, 2021 at 21:56
can you edit your post to include a picture of the conditional format manager? — Scott Craner
– Scott Craner, Commented Aug 23, 2021 at 21:57

Mario Javier Eugenio Estrada · Accepted Answer · 2021-08-23 23:33:07Z

1

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

answered Aug 23, 2021 at 23:33

Mario Javier Eugenio Estrada

3371 silver badge10 bronze badges

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

1 Comment

Seven Over a year ago

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

Collectives™ on Stack Overflow

Excel Conditional Formatting Based on Another Cell

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related