How to color a cell based on value

FischerBuechele 

With your permission, I recommend to provide more information.

You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.

I recommend: Always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).

If possible, add a file (without sensitive data) and use this file to describe your project step by step, or add photos with the appropriate description (step by step – Cell by Cell).

Don't forget that not every Excel user has a clue about every job and what you see he can't see.

In this link you will find some more information about it:

Welcome to your Excel discussion space!

Thank you for your understanding and patience

 Hope I was able to help you with this information.