Posted to microsoft.public.excel.misc

Mandy

external usenet poster

Posts: 55

Conditional formating

Is there a way to do it for the whole sheet. The formula won't work for the
whole sheet.
I used =isns(a2:p500)

"Mandy" wrote:

I have entered a VLOOKUP formula. What do I put in the condtional formating
section so that it will not show the #N/A return? I can not remember.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
conditional formating	ingalla	Excel Discussion (Misc queries)	2	March 2nd 08 04:38 PM
Conditional Formating IS: Help With ANY VALUE	Paperback Writer	Excel Discussion (Misc queries)	6	December 1st 06 09:33 PM
Conditional formating a row	bgl	Excel Worksheet Functions	1	August 10th 06 04:09 PM
Install dates formating using conditional formating?	Jerry Eggleston	Excel Discussion (Misc queries)	2	November 9th 05 05:49 PM
Conditional formating	Esrei	Excel Discussion (Misc queries)	4	March 2nd 05 12:34 PM

All times are GMT +1. The time now is 04:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us