linking worksheets

[rc]

I am trying to get items I add to my "sold" sheet to mark
that item in my "inventory" sheet. If it could mark the
item on the "inventory" sheet by changing the color of
the marked items' cell or letters would be ideal.
Can Excel do this and if so how?

 

[Debra Dalgleish]

You can use conditional formatting to mark the items:

Name the list of item numbers on the Sold sheet (e.g. ItemList).
You can use a dynamic formula to name the range, so the list
will expand automatically. There are instructions here:
http://www.contextures.com/xlNames01.html#Dynamic
On the Inventory sheet, select the column with item numbers
Choose Format>Conditional Formatting
From the first dropdown, choose Formula Is
Type a formula that refers to the active cell in the selection.
For example, if column A is selected:
=COUNTIF(ItemList,A1)
Click the Format button, and on the Pattern tab, select a colour
Click OK, click OK

 

[rc]

Thank you Debra.

-----Original Message-----
You can use conditional formatting to mark the items:

Name the list of item numbers on the Sold sheet (e.g. ItemList).
You can use a dynamic formula to name the range, so the list
will expand automatically. There are instructions here:
http://www.contextures.com/xlNames01.html#Dynamic
On the Inventory sheet, select the column with item numbers
Choose Format>Conditional Formatting
From the first dropdown, choose Formula Is
Type a formula that refers to the active cell in the selection.
For example, if column A is selected:
=COUNTIF(ItemList,A1)
Click the Format button, and on the Pattern tab, select a colour
Click OK, click OK



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.