| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formating/Excel 2007 to 2003 | Excel Discussion (Misc queries) | |||
| Excel Conditional Formating | Excel Discussion (Misc queries) | |||
| Simultaneously use VLOOKUP and HLOOKUP in EXCEL 2003 | Excel Worksheet Functions | |||
| Yet another conditional formating question (Excel 2003) | Excel Discussion (Misc queries) | |||
| Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Linear Mode
