| Home |
| Search |
| Today's Posts |
|
#4
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? |
| 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) | |||
![Ashish Mathur[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
