+ Reply to Thread
Results 1 to 2 of 2

Divide a number into multiple columns

  1. #1
    Registered User
    Join Date
    03-04-2009
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    16

    Divide a number into multiple columns

    Hi,

    I am creating a spead sheet to divide a number over a few rows of colums which will either input a colour or the number its been divided by... i.e 2 (every number will always be divided by 2, as the cost is £2). So if some one pays £10 the sum=10/2=5, so 5 boxes would be filled green. Also if that person pays another £6 it will fill the next three boxes (sum=6/2=3) not the same boxes that have been done before. So im think i will need a formula or fuction for each person as they each have there own row. So an input box and button might be needed aswell.

    Any help been pointed in the right direction, or will this need VB?

    I excel.jpg

    Thanks Phil

  2. #2
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Divide a number into multiple columns

    You can do this with a conditional format.

    If your table of dates runs from column B to column Z then select them, set up a conditional format based on a formula and, as the formula, put

    =(COLUMN()-1)<=(SUM(INDIRECT("B" & ROW()+13 & ":Z" & ROW()+13))/2)

    You can set up the conditional format to colour the boxes whatever colour you like.

    Oh, and your attachment is awesome!

+ 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