View original (French)

Conditional formatting with #NA

Playa2 -  
 Playa2 -
Hello,

I am looking to conditionally format all cells containing #NA.

I tried using Excel's conditional formatting with #NA or ISNA but without success;

Does anyone know the procedure if it is possible with Excel 2002?

Thank you in advance.

2 answers

  1.
    chossette9 Posted messages 6855 Registration date   Status Contributor Last intervention   1 313
     
    Hello,

    in Excel 2002:
    Format -> Conditional Formatting
    select 'Formula Is' from the left list
    type the formula =ISNA(D4) (given cell number as an example)
    choose the format, then OK
    select the cell you just formatted -> copy -> select the cells you also want to apply this formatting to -> click on the paintbrush 'Format Painter'

    Best regards.

    --
    This guy wasn't bright, because he was naive.
    1
  2. Playa2
     
    Hello,

    Great, thank you very much Chossette9, it works perfectly!!!

    Have a nice day
    0