View original (French)

Conditional formatting with 2 conditions

Solved
happydays Posted messages 32 Registration date   Status Membre Last intervention   -  
 Emilie -
Hello,

I have tried the solutions mentioned in the forums, but I can't manage to apply color to a cell with two conditions:

I want the cells in column N to be colored if both of the following conditions are met: the adjacent cell in O is empty, and the adjacent cell in R contains "Facturé".

I believe I have read all the proposed solutions, but the formula I'm entering does not work

=AND($O:$O="", $R:$R="Facturé")

Could someone please help me? Thank you in advance

Configuration: Windows Vista / Internet Explorer 7.0

2 answers

Answer 1 / 2
Ricky38 Posted messages 5776 Registration date   Status Contributor Last intervention   1 463
 
Hi,

try this instead:
Select your cell or range of cells and in conditional formatting you put: 
 =AND($O1="";$R1="Billed")
48
happydays Posted messages 32 Registration date   Status Member Last intervention   1
 
Thank you very much, it works. Why make it complicated when you can keep it simple.
Have a good day.
1
Candy58
 
Great, it works!
0
ju
 
thank youuuu
0
Thomas
 
Top
0
Emilie
 
simple and super practical. Thank you!
0