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

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