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

  • Thread starter Thread starter Shikha
  • Start date Start date
S

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?
 
Insert =ISERROR( ) function in CF condition with the appropriate cell
reference!

Regards,
Stefi

„Shikha†ezt írta:
 
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
 
Use something like this:

=ISERROR(HLOOKUP(....))

as your CF formula.

Hope this helps.

Pete
 
Back
Top