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

[Shikha]

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?

 

[Stefi]

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

Regards,
Stefi

„Shikha†ezt írta:

 

[Ashish Mathur]

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

 

[Pete_UK]

Use something like this:

=ISERROR(HLOOKUP(....))

as your CF formula.

Hope this helps.

Pete