View original (French)

Conditional formatting with 3 conditions

Solved
laurence -  
yao.chris Posted messages 95 Status Member -
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

2 answers

  1.
    Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    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.
    0
    1. yao.chris Posted messages 95 Status Member 2
       
      Good evening Mike_31

      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
      0
    2. laurence
       
      Thank you very much for your responses!
      0
    3. Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
       
      Hi Yao, Chris,

      Not in conditional form, just

      =AND(B2>$K$1;D2=$K$2;F2>$K$3)

      best regards
      Mike-31
      0
    5. Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
       
      Hey buddy,

      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!
      0