Posted to microsoft.public.excel.misc

BeckyB

external usenet poster

Posts: 16

Conditional format Formula -Duplicate & n/a

I am trying to do a conditional format formula to highlight duplicate
results, but I have #n/a on some. Is there a way to write the formula to find
all duplicates in 1 column, but ignore all #n/a values too?

Thanks,
BeckyB

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 Format Formula Help	Minitman	Excel Worksheet Functions	2	December 3rd 09 01:40 PM
Conditional Format - Formula	Ash	Excel Discussion (Misc queries)	9	October 31st 08 02:16 PM
formula for Conditional Format	TUNGANA KURMA RAJU	Excel Discussion (Misc queries)	9	January 15th 07 02:27 PM
Conditional Format & Formula	Bob	Excel Worksheet Functions	2	November 3rd 06 09:27 PM
Conditional format with a formula	Mike Echo	Excel Worksheet Functions	6	July 19th 05 11:05 AM

All times are GMT +1. The time now is 08:19 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us