Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 28

conditional format question

I am looking to highlight duplicates in one workbook based on values from
another workbook

testbook! sheet1 A1:A10
values contain text string

linkedbook! sheet1 A1:A50
values contain text string

any duplicates in linkedbook! will be hightlighted in testbook!

I know how to use conditional formatting but need a little guidance when
linking to another workbook.

thank you in advance of any help

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	tbernhardt	Excel Worksheet Functions	1	October 12th 09 08:48 PM
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
Conditional Format Question	carl	Excel Worksheet Functions	3	June 28th 06 03:42 PM

All times are GMT +1. The time now is 02:30 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us