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

    Cell coloring using if function

    yes now what I've tried is for a range R = Range($A3:$F200) for each Cell in R and then the cases ..... but I need for formatting to be effected for only $A:$F how do code that bit in? at the moment cell.entirerow.interior.color = rgb(192,192,192) for example would highlight the...
  2. T

    Cell coloring using if function

    Dont know whether I should be asking here.... but this gets into VB territory..... Conditional interior cell color... How do I find a cellvalue say "V" on Active Sheet and then select only rows (a:f) for the rows that have "V" in them ..... and then If < the condition you can...
  3. T

    Array to clear Blanks - formula analysis and possible modification

    Anyways all sorted .... for now :) {=INDEX(A:A,SMALL(IF(BlanksRange<>"",ROW(BlanksRange),""),ROW(A1)),1)}
  4. T

    Array to clear Blanks - formula analysis and possible modification

    Hi Hui, Many thanks for taking the time out for this and its just that in a forum thats got no way of attaching files, images making it that much more frustrating and my not wanting to carry on in here but for your efforts thats made me continue... :) thank you. Well, I've broken down the...
  5. T

    Array to clear Blanks - formula analysis and possible modification

    Hi, I'm trying to evaluate the array formula to demonstrate its working... Also interested in creating one that might work without the use of arrays..? Formula being evaluated ...
Back
Top