Using Conditional Formatting to find common cells betweenworksheets

[William Loring]

A while back, I asked here how to use Conditional Formatting to find common
cells between worksheets. Folks here were kind enough to help me with this
problem, and I got it working quite well. Of course, I didn't properly
document my solution, and now I want to recreate it. I'm hoping the list can
come to my rescue again.

I have two worksheets, one with a column of part numbers, and another with a
subset of those part numbers. The main list is set with conditional
formatting to highlight the numbers that appear in the sheet with the subset
list. The formula looks like this: Formula is: =MATCH(A1,XXX,0)>0

I understand that "A1" is the first reference to my column of part numbers.
I also understand that the "XXX" was a trick to be able to reference a cell
range in another worksheet, but I can't figure out how this part works.

If anyone can help me with this part of the puzzle, I would greatly
appreciate it. And I promise to store this data away next time.




William Loring | Marketing
__________________________________________________________

The Tire Rack
7101 Vorden Parkway
South Bend, IN 46628
O: 888 541 1777 ext. 225
O: 574 287 2345 ext. 225
F: 574 236 7714
(e-mail address removed)

http://www.tirerack.com

 

[JE McGimpsey]

A while back, I asked here how to use Conditional Formatting to find common
cells between worksheets. Folks here were kind enough to help me with this
problem, and I got it working quite well. Of course, I didn't properly
document my solution, and now I want to recreate it. I'm hoping the list can
come to my rescue again.

Before reinventing the wheel (or perhaps the tire, in this case), does
this help?

http://groups.google.com/groups?q=author:[email protected]

 

[William Loring]

Before reinventing the wheel (or perhaps the tire, in this case), does
this help?

http://groups.google.com/groups?q=author:[email protected]

Thanks for pointing me in the correct direction. I should know by now that
Google is the answer to nearly any question.




William Loring | Marketing
__________________________________________________________

The Tire Rack
7101 Vorden Parkway
South Bend, IN 46628
O: 888 541 1777 ext. 225
O: 574 287 2345 ext. 225
F: 574 236 7714
(e-mail address removed)

http://www.tirerack.com