In MS Excel 2003, need to do conditional formating on HLOOKUP
 

I need to paint the result of HLOOKUP in red if it returns #N/A or #REF, but
conditional formatting formula is not able to equate #N/A as a string. Anyone
knows how to do this?

In MS Excel 2003, need to do conditional formating on HLOOKUP
 

Insert =ISERROR( ) function in CF condition with the appropriate cell
reference!

Regards,
Stefi

€žShikha€� ezt Ã*rta:

I need to paint the result of HLOOKUP in red if it returns #N/A or #REF, but
conditional formatting formula is not able to equate #N/A as a string. Anyone
knows how to do this?

In MS Excel 2003, need to do conditional formating on HLOOKUP
 

Hi,

you can try this formula in conditional formatting (Format Conditional
formatting)

=OR(ERROR.TYPE($D$11)=4,ERROR.TYPE($D$11)=7)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Shikha" wrote in message
...
I need to paint the result of HLOOKUP in red if it returns #N/A or #REF,
but
conditional formatting formula is not able to equate #N/A as a string.
Anyone
knows how to do this?

In MS Excel 2003, need to do conditional formating on HLOOKUP
 

Use something like this:

=ISERROR(HLOOKUP(....))

as your CF formula.

Hope this helps.

Pete

On Feb 26, 12:00*pm, Shikha wrote:
I need to paint the result of HLOOKUP in red if it returns #N/A or #REF, but
conditional formatting formula is not able to equate #N/A as a string. Anyone
knows how to do this?