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

    Data Labels in an Excel Chart - Changing the green color to a different shade.

    I apologise for not being very clear in my question. I wanted to avoid changing several data label colors manually. I have placed a custom format for my data - [Red]$#,##0_);[Green]($#,##0). The green is a bright color and wanted to tone it down ( without doing it manually). Is there something I...
  2. L

    Data Labels in an Excel Chart - Changing the green color to a different shade.

    Hi, I have read through here and found wher you can custom the data labels with colors. I am wondering if there is way to change the green to a different shade. It is too bright and hard to read. Thank You !!!!
  3. L

    lookup formula based on a partial cell reference

    That works the best so far but not completely. Thank you for your help !!!! I appreciate it.
  4. L

    lookup formula based on a partial cell reference

    I can try this but I am not sure this will work. Is there anything where I can say something like - look a the first 4 or 5 letters, or the first word and ignore the punctuation. It isnt that the Suppliers are mispelled, its more like the CO or Inc or LLC at the end and the punctuation.
  5. L

    lookup formula based on a partial cell reference

    Hi, I have been trying to figure out how to make write a formula that will take one column and match another column based on only a partial value. My example is as follows. I have one list with Supplier names in the first column and dollar amounts in the second column. I have another list with...
Back
Top