| 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? |
| 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) | |||
Threaded Mode
