Setting a cell based on the conents of another

Hey everyone,

I'm working on a workbook that imports data from another source and then displays it nicely in excel. One of my worksheets displays an inventory. On this sheet is a column called "Source" (column D) and and several columns that are only relevant for purchased items. However, if the inventory item's source is "Manufactured", there is no need for these columns, so I would like these cells greyed out in the row for a manufactured item.
The code that I currently have is:

Please Login or Register  to view this content.

Where n is the current row that is cycled through with a for loop.

My intention is that this checks the cell in the source column to see if it is marked "Manufactured," and if it is, then fills in the cells in the vendor columns with a gray background. However, it just fills in the Vendor columns if the "Source" column is empty, and leaves them blank if it contains any term at all.

What am I doing wrong?

Thanks in advance for any help,
Zach

PS. I do realize that the Offset property is being used, that is taking into account columns that had to be added in a different part of the code.

I'm assuming Manufactured is not a variable containing the text "Manufactured"? You just need to wrap it in quotes:

Please Login or Register  to view this content.

Works great now, can't believe I didn't think of that.

Thanks