Conditional Formatting - #N/A Errors
 

Dear Excel Gurus,

I have a workbook containing several VLOOKUP functions. I would like to
format cells with a red fill colour if the result for the vlookup is false
and a #N/A error message appears to highlight them in the spreadsheet.

I've tried both if cell value is #N/A and Formula is =c1=#n/A and various
variations, but no luck! Any suggestions?

Regards
JD2

Conditional Formatting - #N/A Errors
 

Try formula is

=ISNA(C1)

should do it


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"JD2" wrote in message
...
Dear Excel Gurus,

I have a workbook containing several VLOOKUP functions. I would like to
format cells with a red fill colour if the result for the vlookup is false
and a #N/A error message appears to highlight them in the spreadsheet.

I've tried both if cell value is #N/A and Formula is =c1=#n/A and various
variations, but no luck! Any suggestions?

Regards
JD2

Conditional Formatting - #N/A Errors
 

Try one of these:

Formula Is:

=ISNA(C1)

=ISERROR(C1)

Biff

"JD2" wrote in message
...
Dear Excel Gurus,

I have a workbook containing several VLOOKUP functions. I would like to
format cells with a red fill colour if the result for the vlookup is false
and a #N/A error message appears to highlight them in the spreadsheet.

I've tried both if cell value is #N/A and Formula is =c1=#n/A and various
variations, but no luck! Any suggestions?

Regards
JD2

Conditional Formatting - #N/A Errors
 

Thank you,

=isNA(c1) worked a treat!

Regards
JD

"T. Valko" wrote:

Try one of these:

Formula Is:

=ISNA(C1)

=ISERROR(C1)

Biff

"JD2" wrote in message
...
Dear Excel Gurus,

I have a workbook containing several VLOOKUP functions. I would like to
format cells with a red fill colour if the result for the vlookup is false
and a #N/A error message appears to highlight them in the spreadsheet.

I've tried both if cell value is #N/A and Formula is =c1=#n/A and various
variations, but no luck! Any suggestions?

Regards
JD2

Conditional Formatting - #N/A Errors
 

Dear Peo,

Thank you for the quick response ... the formula =isna(c1) worked a treat!

Regards
JD2

"Peo Sjoblom" wrote:

Try formula is

=ISNA(C1)

should do it


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"JD2" wrote in message
...
Dear Excel Gurus,

I have a workbook containing several VLOOKUP functions. I would like to
format cells with a red fill colour if the result for the vlookup is false
and a #N/A error message appears to highlight them in the spreadsheet.

I've tried both if cell value is #N/A and Formula is =c1=#n/A and various
variations, but no luck! Any suggestions?

Regards
JD2

Conditional Formatting - #N/A Errors
 

My pleasure, thanks for the feedback

Peo


"JD2" wrote in message
...
Dear Peo,

Thank you for the quick response ... the formula =isna(c1) worked a treat!

Regards
JD2

"Peo Sjoblom" wrote:

Try formula is

=ISNA(C1)

should do it


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"JD2" wrote in message
...
Dear Excel Gurus,

I have a workbook containing several VLOOKUP functions. I would like
to
format cells with a red fill colour if the result for the vlookup is
false
and a #N/A error message appears to highlight them in the spreadsheet.

I've tried both if cell value is #N/A and Formula is =c1=#n/A and
various
variations, but no luck! Any suggestions?

Regards
JD2

Conditional Formatting - #N/A Errors
 

You're welcome. Thanks for the feedback!

Biff

"JD2" wrote in message
...
Thank you,

=isNA(c1) worked a treat!

Regards
JD

"T. Valko" wrote:

Try one of these:

Formula Is:

=ISNA(C1)

=ISERROR(C1)

Biff

"JD2" wrote in message
...
Dear Excel Gurus,

I have a workbook containing several VLOOKUP functions. I would like
to
format cells with a red fill colour if the result for the vlookup is
false
and a #N/A error message appears to highlight them in the spreadsheet.

I've tried both if cell value is #N/A and Formula is =c1=#n/A and
various
variations, but no luck! Any suggestions?

Regards
JD2

Conditional Formatting - #N/A Errors
 

Hi all,
I was trying to do the same thing, but wanted to apply this to the whole
spreadsheet with conditional formatting. It works for individual cells, but
will not work for multiple cells.

Thanks,
Leo

"JD2" wrote:

Dear Excel Gurus,

I have a workbook containing several VLOOKUP functions. I would like to
format cells with a red fill colour if the result for the vlookup is false
and a #N/A error message appears to highlight them in the spreadsheet.

I've tried both if cell value is #N/A and Formula is =c1=#n/A and various
variations, but no luck! Any suggestions?

Regards
JD2

Conditional Formatting - #N/A Errors
 

It will work happily for the whole sheet.
Formula is =ISNA(A1)
--
David Biddulph

"Leo" wrote in message
...
Hi all,
I was trying to do the same thing, but wanted to apply this to the whole
spreadsheet with conditional formatting. It works for individual cells,
but
will not work for multiple cells.

"JD2" wrote:

Dear Excel Gurus,

I have a workbook containing several VLOOKUP functions. I would like to
format cells with a red fill colour if the result for the vlookup is
false
and a #N/A error message appears to highlight them in the spreadsheet.

I've tried both if cell value is #N/A and Formula is =c1=#n/A and various
variations, but no luck! Any suggestions?

Regards
JD2

Conditional Formatting - #N/A Errors
 

Thanks. I had misinterpreted that "A1" meant that I entered all cell
references, not just "A1".

"David Biddulph" wrote:

It will work happily for the whole sheet.
Formula is =ISNA(A1)
--
David Biddulph

"Leo" wrote in message
...
Hi all,
I was trying to do the same thing, but wanted to apply this to the whole
spreadsheet with conditional formatting. It works for individual cells,
but
will not work for multiple cells.

"JD2" wrote:

Dear Excel Gurus,

I have a workbook containing several VLOOKUP functions. I would like to
format cells with a red fill colour if the result for the vlookup is
false
and a #N/A error message appears to highlight them in the spreadsheet.

I've tried both if cell value is #N/A and Formula is =c1=#n/A and various
variations, but no luck! Any suggestions?

Regards
JD2