Posted to microsoft.public.excel.worksheet.functions

Gotroots

external usenet poster

Posts: 114

Conditional format question

What formula is suitable to determine if a value in 'B' is not present in A:A

example:

oranges are in B3 but can not be found anywhere in A:A

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 question	CP	Excel Discussion (Misc queries)	1	June 9th 09 04:16 PM
Conditional Format Question	Kevin	Excel Discussion (Misc queries)	4	June 19th 07 04:26 AM
Another Conditional Format Question	PT	New Users to Excel	3	April 29th 07 02:42 AM
question about conditional format	Jack Sons	Excel Discussion (Misc queries)	4	October 10th 06 08:12 PM
Conditional Format Question	DougS	Excel Worksheet Functions	3	May 3rd 05 01:36 AM

All times are GMT +1. The time now is 06:25 PM.

About Us

"It's about Microsoft Excel"