Excel 2007 : Conditional format based on if data changes?

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.

Yeah, sorry I couldn't explain the problem any better, but I solved it! Took me some thinking of a way to do it, but this is what I did.

I enabled column sorting (is that what it's called?), this is when the columns have a little drop down box. Then I sorted size to show only XL and 3X (I didn't show it in the example, but I had some other sizes too).. then I selected and BOLDED what I needed with one press. Then Underlined everything with thick bottom border with one press that I needed to.

Afterwards I undid that the sorting so I could see all again.

For next time I am going to see if I can figure out how to sort like that then automatically add a page break. Because the warehouse wanted one order per page, and I sat there and manually adjusted 79 page breaks.