How to color a cell based on value

Copper Contributor

Need help coloring the cells b:2-B:10 red or green based on their value relative higher or lower to cells D:4-D:7.

1 Reply

@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.