Conditional Formatting - recognise #N/A

's Computer Specifications

Hi Everyone

I would like to use Conditional Formatting to highlight for me when #N/A is
the result of a formula.

(I have used Conditional Formatting before for number values, but this has
me stumped!)

Many thanks!

's Computer Specifications

Use the Formula Is option in conditional formatting and use this formula:

=ISNA(cell_reference)

Replace cell_reference with the actual cell reference.

--
Biff
Microsoft Excel MVP

"LinLin" <(E-Mail Removed)> wrote in message
news:0C9F6F34-5B38-4CB2-A373-(E-Mail Removed)...
> Hi Everyone
>
> I would like to use Conditional Formatting to highlight for me when #N/A
> is
> the result of a formula.
>
> (I have used Conditional Formatting before for number values, but this has
> me stumped!)
>
> Many thanks!

's Computer Specifications

That was very cool T. Valko - many thanks and have a great weekend!

"T. Valko" wrote:

> Use the Formula Is option in conditional formatting and use this formula:
>
> =ISNA(cell_reference)
>
> Replace cell_reference with the actual cell reference.
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "LinLin" <(E-Mail Removed)> wrote in message
> news:0C9F6F34-5B38-4CB2-A373-(E-Mail Removed)...
> > Hi Everyone
> >
> > I would like to use Conditional Formatting to highlight for me when #N/A
> > is
> > the result of a formula.
> >
> > (I have used Conditional Formatting before for number values, but this has
> > me stumped!)
> >
> > Many thanks!
>
>
>

's Computer Specifications

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP

"LinLin" <(E-Mail Removed)> wrote in message
news:B5AFFB9B-15A8-4B6B-8676-(E-Mail Removed)...
> That was very cool T. Valko - many thanks and have a great weekend!
>
> "T. Valko" wrote:
>
>> Use the Formula Is option in conditional formatting and use this formula:
>>
>> =ISNA(cell_reference)
>>
>> Replace cell_reference with the actual cell reference.
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "LinLin" <(E-Mail Removed)> wrote in message
>> news:0C9F6F34-5B38-4CB2-A373-(E-Mail Removed)...
>> > Hi Everyone
>> >
>> > I would like to use Conditional Formatting to highlight for me when
>> > #N/A
>> > is
>> > the result of a formula.
>> >
>> > (I have used Conditional Formatting before for number values, but this
>> > has
>> > me stumped!)
>> >
>> > Many thanks!
>>
>>
>>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Sum function does recognise %	Geoff Newham	Microsoft Excel Worksheet Functions	2	28th Jul 2009 10:14 AM
Conditional Formatting of text effecting formatting of background	=?Utf-8?B?SEFI?=	Microsoft Access Reports	6	25th Mar 2008 06:23 PM
Conditional Formatting No Longer Conditional in 2007 Beta	=?Utf-8?B?Q2FjdHVhci1Oby1KdXRzdQ==?=	Microsoft Excel Crashes	0	17th Nov 2006 10:01 PM
How do I do a complex conditional in a conditional formatting formula	Ray Stevens	Microsoft Excel Discussion	7	12th Mar 2006 10:24 PM
Conditional Formatting that will display conditional data	=?Utf-8?B?QnJhaW5GYXJ0?=	Microsoft Excel Worksheet Functions	1	13th Sep 2005 05:45 PM