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

    Conditional Formatting - cFormat Macro Code

    I see what you mean. So in your code it looks to match exacts I think. My Format list for instance has BP, CM. My data would have BP Plant1, CM Plant 1. Anyway I could have it still match say the first 2 or 3 characters. Also Hui thanks for help me out, you've been a life saver and I'm...
  2. C

    Conditional Formatting - cFormat Macro Code

    Hi Hui, Thanks for your help. I see what your code does but I need to tweak it a little bit. In your example, if I relate it to the original macro, it uses conditions2use to find where to format to and then formats the corresponding cell in data2use. In your code you are directly formatting...
  3. C

    Conditional Formatting - cFormat Macro Code

    Hi Guys, I was wondering if I could get a hand. I've been trying to modify the code provided on the page http://chandoo.org/wp/2008/10/14/more-than-3-conditional-formats-in-excel/ so that instead of using numbers in the conditions2use part, it uses text. E.g. Instead of 1 its BP, 2 is CM...
Back
Top