View original (French)

Conditional formatting with multiple conditions

Solved
Anthony882000 Posted messages 3 Registration date   Status Membre Last intervention   -  
Vaucluse Posted messages 27336 Registration date   Status Contributeur 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 réponse

Réponse 1 / 1
Vaucluse Posted messages 27336 Registration date   Status Contributeur 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
Anthony882000 Posted messages 3 Registration date   Status Membre 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
Vaucluse Posted messages 27336 Registration date   Status Contributeur 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
Anthony882000 Posted messages 3 Registration date   Status Membre 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
Vaucluse Posted messages 27336 Registration date   Status Contributeur Last intervention   6 453
 
OK, I consider the issue resolved
Safe travels
Best regards
0