Conditional formatting with #NA

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

  • Votes
  • Date
  • Descending date
  1. Contributor
    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. Hello,

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

      Have a nice day