+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Conditional format based on if data changes?

  1. #1
    Registered User
    Join Date
    02-14-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2007
    Posts
    6

    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.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,807

    Re: Conditional format based on if data changes?

    Apart from using VB, I dont think there is anyway to change the format of a cell simply because the contents changed from something, to something else. Conditional formatting works based on a cell's contents changing to/from a user-specified value, and this is not what you are describing.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    02-14-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Conditional format based on if data changes?

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1