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 réponses

Réponse 1 / 2
ccm81 Posted messages 11033 Status Membre 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
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
Hcc
 
Thank you very much, 5 years later, it’s still useful!
Wishing you all the best!
0