Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional format when #N/A
Hi,
I have a Vlookup function in column H of a worksheet (which is written in code as part of a macro). I want to do conditional formatting if the vlookup result is #N/A (which I would also like to be part of my macro). I need to do this for all the cells in column H, not just one specific cell. In the worksheet, I may or may not have a #N/A to highlight. Any help would be GREATLY APPRECIATED...as I have been trying to figure this out for 3 hours now. Thanks, Sara |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep conditional format when "show pages" from Pivot table | Excel Discussion (Misc queries) | |||
How do I do a conditional format for numbers | Excel Worksheet Functions | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Copying a conditional format | Excel Worksheet Functions |