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

    HOW TO COPY CONDITIONAL FORMATTING (CF)

    @XLD...what you told me is not about CF its just simply coloring the rows...its just you didnt understand clearly what i last posted.. @luke...thanks for that...i tried..but it only referred to D1...i selected the range but it did not automatically adjust to D2...D3..D4...it only stayed to D1...
  2. D

    HOW TO COPY CONDITIONAL FORMATTING (CF)

    its not CF.... when i put 1 as the value of D1 or D2 so on...the whole row of D1 or D2..so on..will be green..something like that.
  3. D

    HOW TO COPY CONDITIONAL FORMATTING (CF)

    hello, can you please help me on how to copy the CF i created for a row...to have same effect on other existing rows??? e.g. A1 to D1 if value of D1=1 all rows of A1 till D1 will be green, then..A2 to D2 if value of D2=1 all rows of A2 till D2 will be green and so on and so forth...
  4. D

    =IF(ISTEXT(CELLS),V,SUM(CELLS)

    thanks radu for the effort...its also cool...
  5. D

    =IF(ISTEXT(CELLS),V,SUM(CELLS)

    anyway..thanks for the help...i appreciate it very much.
  6. D

    =IF(ISTEXT(CELLS),V,SUM(CELLS)

    @kchiba...thanks for the try...but still its not summing up..after V or A..big thanks @xld...you got it dude..thanks!!!
  7. D

    =IF(ISTEXT(CELLS),V,SUM(CELLS)

    oh...almost near...its working on "A" and "V" but if letters are present the numbers before and after it is not summing up..for example: 10 10 A A 10 RESULT IS A, it must be 30.
  8. D

    =IF(ISTEXT(CELLS),V,SUM(CELLS)

    oh thanks...i hope you can find a solution to this..am getting a lil bit crazy ..hi hi hi...thanks!!!
  9. D

    =IF(ISTEXT(CELLS),V,SUM(CELLS)

    2003 chief..
  10. D

    =IF(ISTEXT(CELLS),V,SUM(CELLS)

    Hi...thanks for the fast reply...i tried... =IFERROR(HLOOKUP("v",T27:BL27,1,0),IFERROR(HLOOKUP("A",T27:BL27,1,0),SUM(T27:BL27))) it gave me #NAME? =(
  11. D

    Hello .. Introduce yourself

    Hi..am Dean...from Kazakhstan...looking forward to gather new friends and learn to each other using excel...Merry Christmas and Happy New Year..
  12. D

    =IF(ISTEXT(CELLS),V,SUM(CELLS)

    hello, am new here and asking for your advice....am doing timesheet stuff and i wanted to generate a certain formula that goes like this --> IF cells A1 to F1 contains A or V display A or V if not sum the numbers within cells A1 to F1...i hope its clear please help!!!
Back
Top