View original (French)

Color a cell based on the value of another cell

simonngangue -  
 Hcc -
Hello,

I would like to have the procedure in Excel 2007 that allows me to change the color of a cell based on the variable value of another cell.

2 answers

  1.
    ccm81 Posted messages 11033 Status Member 2 434
     
    Hello

    Example: color cell A2 in red if B2 > 5
    You need to create a Conditional Formatting (CF) rule on A2
    Ribbon/tab Home/ icon: conditional formatting
    Choose: new rule
    In the window: "use a formula to determine..."
    =($B$2>5)
    then Format/Pattern ....

    Best regards
    23
    1. Picton86
       
      It's still amazing to find people who share their knowledge. A big thank you to you ccm81, I'm improving even more thanks to you.
      Thank you and all the best for you.
      2
    2. Hcc
       
      Thank you very much, 5 years later, it’s still useful!
      Wishing you all the best!
      0