Forum Discussion

FischerBuechele's avatar
FischerBuechele
Copper Contributor
Aug 10, 2024

How to color a cell based on value

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

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor

    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.