• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. M

    Mass formula to cells

    http://www.sendspace.com/file/xv8oj2 Thanks
  2. M

    Mass formula to cells

    I did try the pivot option to bring in the subtotals and that worked, but i still ran into the issue of trying to work the calculation into the pivot. When i did the calculation in the pivot, it only worked correctly for the 'subtotals' and not the other cells. Can you expand on any...
  3. M

    Mass formula to cells

    What ive done is pulled a report from our database and ive applied a subtotal to columns A-D. Column E, only on the sub total line for each change in value in column A is just a simple division. What i want is the proceeding cells in column to be auto filled with the formula = $E$7 * D6...
  4. M

    Mass formula to cells

    Hey Guys I have an issue which is bugging me and something i dont want to do manually. In the attached document, i need the bolded subtotal in column E to be multiplied by the pertinent cells in column D i.e. cell E7 is 194.94 * D2 = 194.94, cell E7 is 194.94 * D3 = 194.94 and so on. My...
  5. M

    Conditional Formatting a Graph

    Thanks Dan, appreciate the extended answer. One final thing. Ive recreated the book using your steps and ive gotten this to work, however the color coding is the typical red and blue that excel defaults on. For above 80 im getting the red, below 80 im receiving the blue. In your examples, it...
  6. M

    Conditional Formatting a Graph

    Thanks for your reply Dan, this is exactly what i was after. Is it possible for you to explain in greater depth for my knowlegde the use of the if/then and the dynamic ranges? I want to use this in future and apply it to various sheets, so id like to brush up on the theory behind the actual...
  7. M

    Conditional Formatting a Graph

    Hi Guys I want to conditional format a bar graph based on the results within B3-B14. Ive applied a conditional format to B3-B14, in which anything equal or greater than 80 is green and anything less than 80 as red. Essentially i want the graph results for that given month to replicate the...
Back
Top