Format linked workbook cells (updated)

G

gootroots

(This post is being sent again in the hope the example cell content displays
properly for easy viewing, if not then i suggest copy and pasting into a
word document. Thankyou.)

Here is an explanation of what I am trying to achieve. If you need further
clarification please do let me know.

AutoBook1 Sheet1

A10 Make B10 Type1 C10 Type2 D10 Type3

A11 Ford B11 Formatted C11 Formatted D11
A12 Chrysler B12 C12 Formatted D12 Formatted
A13 Toyota B13 Formatted C13 D13
A14 GM B14 Formatted C14 Formatted D14
A15 Honda B15 C15 Formatted D15 Formatted
A16 BMW B16 C16 D16 Formatted


AutoBook2 Sheet2

A9 Make B9 Type1 C9 Type2 D9 Type3

A10 Mercedes B10 C10 value D10 Value
A11 GM B11 value C11 value D11
A12 Toyota B12 value C12 D12
A13 Ford B13 value C13 value D13
A14 BMW B14 C14 D14 value
A15 Honda B15 C15 value D15 value
A16 Chrysler B16 C16 value D16 value


I need code to determine which values belonging in Autobook2 are in
Autobook1. When a match is found in Autobook1 the corresponding cell is
formatted with a border cell colour.

For example Autobook2 A11 GM has a value in B11 which belongs to heading
Type1 in cell B9

Code should then look in Autobook1 and find the value GM in colA11:A16

If found then the code should then look in rowA10:D10 and find the value Type1

If found then format the corresponding cell with a border colour.

Formatted cells in Autobook1 may or may not contain a value.
 
L

Luizvs

I don't think youu need a macro for that. Coudn't you just use conditional
formatting for that?
 
G

Gotroots

Hummm, didn't think conditional formatting could be used where a linked
workbook is involved.

Perhaps if i could have an example to test it out then it perhaps could be
something for me to consider.

Although the example range provided here only includes a few rows and
columns the actual range is approximately 10,000 rows by 60 columns
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top