Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jul 2006
    Location
    Bangalore, India
    Posts
    180
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Conditional Formatting where results of the formula is #NA

    Hi,

    I would like to apply conditional formatting for a cell whose formula result is #N/A. I have tried options like if cell = NA() and if cell = #N/A. Both dont seem to be working.

    Regards
    Baiju

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Use a formula something like (change to the appropriate cell for testing):

    =ISNA(A1)

    ISNA returns true if a #N/A error, false if not.

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts
    If are working with numbers there is always
    = If(ISNA(A1),0,A1)

    TD

  4. #4
    2 Star Lounger
    Join Date
    Jul 2006
    Location
    Bangalore, India
    Posts
    180
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Hi Steve & TD,

    Thanks for the formula, it did work for me.

    Regards
    Baiju

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •