I've been looking for an answer (or something close to one) to a question for quite some time now, and I have exhausted all of my resources.
I have an Inventory Report Spreadsheet that currently imports an inventory report from our system, inputs it in this form, and calculates what needs to be ordered for us to keep stock through the given timeframe (i.e. based on a two week report, how much stock do we have to order to last through the NEXT two weeks). I have a table on my Config worksheet that contains a list of partial SKUs and each SKU is colored a different background color (this is a Named Range called SKUList). I also have a macro that processes the current inventory report, adds a few formulas to figure out what to order, and saves it into a new worksheet in this workbook. what I would like to accomplish is this:
At the end of my Macro, I would like to conditionally format all of the first column (the SKU column, variable: rngSKU As Range) based on text found in the SKU list on my config page, and color the cells based on the color of each cell on the SKU list. So something like
If text(SKUlist) Exists, then
Set Cell Color = Corresponding SKUList Cell
I don't necessarily need a whole Sub typed out, but I am looking for someone who might be able to explain how to do this. I am not a VBA newbie, but I am far from being proficient.
**EDIT**
This is my "formatting" code block:
Bookmarks