+ Reply to Thread
Results 1 to 4 of 4

Format rows based on entery in one cell

  1. #1
    Forum Contributor
    Join Date
    11-20-2012
    Location
    stockholm
    MS-Off Ver
    Excel 2010
    Posts
    123

    Format rows based on entery in one cell

    Hi,

    I'm looking for a macro code that will help me format a list that is constantly updated with new data.

    The list contains recipes for the product my company sells. The list is each week updated with new recipes or changes in recipes. Today I manully draw a line between each recipe, I have a colum on the the right side of the list calculating the total procentage in the recipe to controll they add up to 100%. If a cell in this column says 100% I would like a macro to draw a bottom line in that cell as well as in all cells in that row.

    I have attached a example file to show you what I mean. (Obs I cant use the product name in col A to determine when a recipe starts cause sometimes there are several recipes for the same product - as you see for Prod D in the example).

    Thanks for any help,
    Martin
    Attached Files Attached Files
    Last edited by masben; 04-25-2013 at 04:36 AM.

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Format rows based on entery in one cell

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    11-20-2012
    Location
    stockholm
    MS-Off Ver
    Excel 2010
    Posts
    123

    Re: Format rows based on entery in one cell

    Thanks!

    Works perfect.
    You saved me lots of time now - happy!!

    //Martin

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Format rows based on entery in one cell

    Martin,
    You are welcome!

+ 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