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

    conditional formatting problem

    I have a file that has a lot of conditional formatting based on dates like a gantt chart. when status gets updated the logic has to be redone and i have to re-organize my tasks to match the new logic, however, all the indicators are visually seen on the gantt. I need those exact indications to...
  2. G

    Conditional Formating Problem, not updating

    the best practice that i have come accross is to select the first cell "leading cell" that will be affected by the conditional format and put in the formula. once it is set, I apply the range that will be affected in the "applies to" field. after that, i don't have issues. I can add and subtract...
  3. G

    Conditional Formating Problem, not updating

    have you checked your conditional formating under "applies to" field, sometimes adding a row can change the "applies to" and has be adjusted.
  4. G

    link MS project start and finish dates to excel

    I have a MS project file that I want to link to in excel. So if I update the dates on MS project they will update in excel. I have gone through the select the dates, paste special link, and text. I have also done the same on paste special link for excel format but after i close the files and...
  5. G

    Super Complex Logic Formula (at least to me)

    do you have a worksheet example you can post?
  6. G

    array formula

    put in a link and i should be able to get it.
  7. G

    array formula

    i think i can get access, but not post.
  8. G

    array formula

    Sorry I tried every option to share my file and due to the nature of my work, all sites are blocked or not working. I will try to type it here 'ID# 'Part 'Number1 'Part number2 'part number3 'Part number4 'Part number5 Etc... ' 1 '4732984709 '49857hhH58 '13987329 '165489f...
  9. G

    array formula

    Sorry I tried every option to share my file and due to the nature of my work, all sites are blocked or not working. I will try to type it here 'ID# Part Number1 Part number2 part number3 Part number4 Partnumber5 Etc... ' 1 4732984709 49857hhH58 13987329 165489f...
  10. G

    array formula

    I have a list of ID numbers, in these ID number are 6 columns of possible part numbers. I have another tab that has the part number it is looking for and wants to see if that number is one of the 6 possible numbers and if so, what is the ID number. i tried an array formula, but it only works...
  11. G

    Font style specified in formula, for dashboards?

    Great, thanks everyone for your input.
  12. G

    Font style specified in formula, for dashboards?

    the KPI dashboard has an arrow icon, but it only goes one way, i want the icon, for negative values, to go to the right and not just the left. that way it doesn't confuse the user. i have however, conditionally formatted it for green for positive and red for negative, but not satisfied.
  13. G

    How to Protect a Workbook from SAVE

    Sorry Hui, guess you answered while i was.
  14. G

    How to Protect a Workbook from SAVE

    have you tried saving it as a read only recommended file, that way when they open it they open it in read only then do their import, get their print out and close it. to do this you can go to Save as, then click Tools near the save button, then click general options and select 'read only...
  15. G

    Font style specified in formula, for dashboards?

    Is it possible to specify a font style in a formula, kind of like the Text(1564,###.0) formula but font style? I want to add a webdings character in the answer of my formula.
  16. G

    chart titles, axis, and legend not printing

    That was it, thank you very much!
  17. G

    chart titles, axis, and legend not printing

    I have 3 charts i am trying to print. they all have a title, legend and full axis. However, when i try to print them no axis shows up, no titles, and no legend, just the legend icon or indicator with no text. any suggestions?
  18. G

    selecting range based on cell value

    Your Awesome!! thanks a bunch.
  19. G

    selecting range based on cell value

    I want to know how can i select a range of cells and count the non blanks based on a cell value of my end range. for example. i have a value of 3 in cell A1,and i am on range b1. Based on the cell value of 3 in A1, count the nonblanks from b1 and 3 cells down?
  20. G

    Add a New menu on Mouse right for workbook Navigation

    That is really awesome. i am going to study it to see how it works. again, Very cool.
  21. G

    Numbers to Text - High Volume

    be sure you apply this to the range your info is located.
  22. G

    Numbers to Text - High Volume

    instead of formatting the column as text, use can use a custom format. go to format cells by right clicking, choose custom. In the field called Type: put in 000000. that should do the trick.
  23. G

    rounding of average value

    =ROUND(SUM(C+D)*10/100,1) put round in front of your sum equation. then after the equation you need to put the number of digits(decimal places) you want rounded to.
  24. G

    Hello .. Introduce yourself

    My name is Greg. This is such an Awesome site. use it everyday. Currently live in KY. Thanks Chandoo and other contributors.
  25. G

    picture chart thats graphically shows % complete

    Thanks everyone, finally figured it out. i used a picture and cut it up into the sections I needed. then i made a sigle bar chart and formatted it will a fill on the clipboard. then peiced them all together. Thanks.
Back
Top