Change conditional format script

  • Is there a way to change the below script so that it does not highlight values that are "0"?


  • Re: Change conditional format script


    Well, I'm trying to do the conditional formatting by rows rather than manually doing it....

  • Re: Change conditional format script


    Quote from royUK;726754

    Your code will loop 10000 times, how can that be better than simply manually setting up the format?


    So are you implying it's easier to do 10000 rows manually vs a script?

  • Re: Change conditional format script


    I'm implying nothing - it's got to be faster and once set up the conditional format is there unless deleted so any code is redundant.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!