Conditional formatting with 3 conditions
Solved
laurence
-
yao.chris Posted messages 95 Status Membre -
yao.chris Posted messages 95 Status Membre -
Hello,
Regarding the conditional formatting of cells in Excel;
I have an Excel document containing 4 pieces of information about a hundred individuals.
I would like to color the names of the individuals for whom different conditions are met (for example: age>30 AND city=Brussels AND income>1000)
I do not know which formula to use and how to use it in the conditional formatting function.
Could someone help me?
Thank you very much
Regarding the conditional formatting of cells in Excel;
I have an Excel document containing 4 pieces of information about a hundred individuals.
I would like to color the names of the individuals for whom different conditions are met (for example: age>30 AND city=Brussels AND income>1000)
I do not know which formula to use and how to use it in the conditional formatting function.
Could someone help me?
Thank you very much
2 réponses
Good evening,
for example, you have column A starting from A2 with the names, column B starting from B2 with the age, starting from D with the city, and starting from F2 with the salary.
start by highlighting your range A2:last cell of your table
conditional formatting, the formula is
=AND(B2>30;D2="brussels";F2>1000)
format and select your format
you can also place the criteria in cells so you can use formatting at your convenience, for example, the age criterion in K1, the city with potentially a drop-down list in K2, the salary criterion in K3
the formula becomes
=AND(B2>$K$1;D2=$K$2;F2>$K$3)
--
Best,
Mike-31
A period of failure is a perfect time to sow the seeds of knowledge.
for example, you have column A starting from A2 with the names, column B starting from B2 with the age, starting from D with the city, and starting from F2 with the salary.
start by highlighting your range A2:last cell of your table
conditional formatting, the formula is
=AND(B2>30;D2="brussels";F2>1000)
format and select your format
you can also place the criteria in cells so you can use formatting at your convenience, for example, the age criterion in K1, the city with potentially a drop-down list in K2, the salary criterion in K3
the formula becomes
=AND(B2>$K$1;D2=$K$2;F2>$K$3)
--
Best,
Mike-31
A period of failure is a perfect time to sow the seeds of knowledge.
I had put an IF in front, is that why it wasn't working???
=IF(AND(B2>30;D2="brussels";F2>1000))
Thank you for your explanations.
Yao
Not in conditional form, just
=AND(B2>$K$1;D2=$K$2;F2>$K$3)
best regards
Mike-31
In case Yao misses my explanations as requested
https://forums.commentcamarche.net/forum/affich-29008740-mise-en-forme-conditionnelle-avec-3-conditions#7
Best regards
All good, coffee and croissant, I’m feeling great like a young one, I think I'm getting younger, I should stop before I fall back into childhood, or even younger with diapers.
As a friend says, the sky is clear and so are the urines, I’m going to work.
Have a good day!