• 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. S

    Auto update a chart color based on values

    Hi, I am preparing a weekly report that measures the employee performance. The bar color should be Red -If value is <=94.99% score, Green If >=95%). Is there any way, using VBA or a macro, to change the color of a bar (data point) automatically based on the value. Can it run through all of...
  2. S

    Excel VBA Macro

    Hi, My data sheet consits of Current week (CW) 44,45,46 etc and Task code A,B,C,D etc. Want to know for Current week-44 how may task A,B,C completed then CW-45 how many task B,C,D completed then so on.... In pivot Table Report Filter filed column draging "Current week", Row Lable "Task code"...
  3. S

    Excel

    Can any body help me to get the Sumproduct concept
  4. S

    VBA Help

    Hi, I am new to Excel VBA programming. Recorded the macro for pivot table but it is not working properly. My data sheet consits of Current week (CW) 44,45,46 etc and Task code A,B,C,D etc. Want to know for Current week-44 how may task A,B,C completed then CW-45 how many task B,C,D completed...
  5. S

    Excel problem

    Hi, Kindly assist me to get the result. Below are the data of the varioius invoices that has been pending report as shown across below. Eg--&#62; All those invoice amounts where the invoice date is within 30 days from todays date needs to be summarized and shown under "0-30 Days", Eg--&#62...
Back
Top