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

Recent content by wannabe_guru

  1. W

    conditional formatting -

    A B C D E F Project # Start 1/1/12 2/1/12 3/1/12 4/1/12 1111 1/15/2012 $10.00 $10.00 $10.00 $10.00 2222 2/9/2012 $20.00 $20.00 $20.00 $20.00 i cant understand, this "whatever" talk you keep mentioning. why...
  2. W

    conditional formatting -

    A B C D E F Project A Start 1-Jan 1-Feb 1-Mar 1-Apr 1111 1/15/2012 $10.00 $10.00 $10.00 $10.00 my forumla should be generated to say, based on the start date in column b, if any cells within the range after the start date has...
  3. W

    conditional formatting -

    i think i figured it out! =IF(SUMPRODUCT((M$9:Z$9>$E11)*(M11:Z11))>0,TRUE,FALSE) i can use this formula in my conditional formatting! :D
  4. W

    conditional formatting -

    Project A Start 1-Jan 1-Feb 1-Mar 1-Apr 1111 1/15/2012 $10.00 $10.00 $10.00 $10.00 What should happe, is that the contents in feb, march, and april should be highlighted. does this example help?
  5. W

    conditional formatting -

    is there anyway to highlight values in a range of cells, based on start dates of a project? for example: Start Date 01/01/12 Project A: has dollars budgeted on it for 02/15/12, then 03/15/12, and 04/15/12. What I would want to do is highlight the cells that have those dollars on them if...
  6. W

    problem copying this stuff down?

    sorry, i think we missed the mark here by a long shot. what should happen is the copy down for the project. i think it was using the copy special functionality for blanks and pasting in the formula.
  7. W

    problem copying this stuff down?

    is there an easier way to get this info copied? i guess my problem is that, they aren't just one cell space between them, some have multiple some have just one, some have none. is there a way to copy this information into teach cell faster than doing it one by one? 14151ABC PROJECT 14151AB...
  8. W

    trying to determine a function to give me a true/false statement

    wowza :D that is pretty freaking cool, now lets see if i can understand it :D
  9. W

    trying to determine a function to give me a true/false statement

    Should be true. The reason is because, there are no dollars allocated after February 2012. So true would be correct. The goal should be - based of the projects start dates, if there are any dollars past that month it goes live, it should be false.
  10. W

    trying to determine a function to give me a true/false statement

    crap it almost came over like it is in the workbook! :( i hope someone who sees this gets what i was trying to make.
  11. W

    trying to determine a function to give me a true/false statement

    Project Go Live Date Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 BUDGET PASS GO LIVE DATE A 10/1/2012 10 10 10 10 10 10 10 10 10 10 10 FALSE B 2/15/2012 10 10 TRUE C 3/30/2012 10 10 10 10 10 10 FALSE D 11/15/2012 10 10 10 10 10 10...
  12. W

    trying to determine a function to give me a true/false statement

    if i have a set of projects with an expected start date - im trying to compare to see if these projects are still budgeting dollars after their start date. i just want to pull something back - via true/false saying. Project A - 5/1/12 Jan-12 $10 Feb-12 $10 Mar-12 $10 Apr-12 $10 May-12...
See more
Back
Top