View original (French)

Conditional formatting with multiple conditions

Solved
Anthony882000 Posted messages 3 Registration date   Status Member Last intervention   -  
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   -
Hello everyone, I have a small problem with my conditional formatting with multiple conditions.

I would like the temperature in column I to display a red cell when the temperature is below 10 degrees but also when it is above 13 degrees. Furthermore, I would like this to apply only to fridge 2 which is mentioned in column H and not to the other fridges.

Here is the formula I have created without much success for now: =IF(AND($H11:$H13157="frigo 2",$I11:$I13157<10,$I11:$I13157>13),"TRUE","FALSE")

While waiting for your possible responses, I thank you in advance.
Best regards.

1 answer

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello
    Conditional formatting by formula with this formula, it should work

    =AND($H11="frigo 2",OR($I11<10,$I11>13))

    In a CF, the IF is not needed and you just need to, after selecting the field to format, enter the formula corresponding to the 1st line in the CF window
    regards

    To err is human, to persist is diabolical
    0
    1. Anthony882000 Posted messages 3 Registration date   Status Member Last intervention  
       
      Thank you for this response. However, when the fridge 2 appears, the cell automatically turns red, whereas if my temperature is between 10 and 13, my cell should be green. How can we resolve this issue? Thank you once again in advance.
      0
    2. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
       
      Indeed, I hadn't anticipated that cell I could be empty and equal to 0 and (therefore less than 10)
      so we need to add a condition to the formula:

      =AND($H11="fridge 2",$I11<>0,OR($I11<10,$I11>13))

      best regards
      0
    3. Anthony882000 Posted messages 3 Registration date   Status Member Last intervention  
       
      It's all good!! It works very well! Thank you again for your help, which has been very valuable to me.
      I wish you a good day.
      Best regards
      0
    4. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
       
      OK, I consider the issue resolved
      Safe travels
      Best regards
      0