Conditional Formatting - recognise #N/A
 

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!

Conditional Formatting - recognise #N/A
 

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" wrote in message
...
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!

Conditional Formatting - recognise #N/A
 

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" wrote in message
...
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!

Conditional Formatting - recognise #N/A
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"LinLin" wrote in message
...
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" wrote in message
...
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!