View original (French)

Conditional formatting with 2 conditions

Solved
happydays Posted messages 32 Registration date   Status Member 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

  1.
    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
    1. 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
    2. Candy58
       
      Great, it works!
      0
    3. ju
       
      thank youuuu
      0
    4. Thomas
       
      Top
      0
    5. Emilie
       
      simple and super practical. Thank you!
      0