I have Excel 2007. I have two different scenerios here, but on the same subject. I will be doing the work often, so thought maybe there's an easier way.

I receive orders from a big company. Their data includes a UPC # for each item and size, but it does not show our Item Number, Color, and the Size. I need this information for our warehouse.

So, longer story short.. I finally get my stuff input and all the data into Excel. This time there's 79 orders total. I used the Subtotal button in Excel to automatically put a line between each order that has the total quantity.

How can I make it automatically bold certain data?

For example, my data is in Cols D - H. When the data in COL D changes I want D-H to be BOLD.

So, say Column D has my Item Number and Column E has my Color. I want it to automatically BOLD when the item/color changes. So, I can have item 1234-5678 in Black, but then Red. I can have item 5555-5555 in Orange. It would be bolding 1234-5678 in Black the first time, then red the first time, then would have bolded 5555-5555 Orange the first time.

I can do this manually, but it's close to 1000 rows in Excel I'd need to go through! Lot of work and room for error.

Here's an example of what I made for the warehouse, put in some dummy data for this website.

worksheet_sample.jpg

In that example I've made it print on one page for each store. I see I've mistakenly bolded the PO # all the way down, but whatever this is just an example. Anyway, you see I have bolded Style, Size, and Color of each one that changed. I have also separated it with an thick bottom border. I'd like to simplify my work in doing that somehow.