Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Toronto, Ontario
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    More than 4 conditional formatting options (2000 SP1 Win NT4 sp6)

    (Edited by HansV to remove duplicate non-functional link)

    Our network systems engineer needs to be able to add additional conditional formatting options: I found a previous thread here at the Lounge and the links below outline how to add a 4th. But he expects he will need many more than 4. Anyone know of any add-ins or a possible solution?
    http://www.mrexcel.com/td0111.html

    Thanks in advance ...

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: More than 4 conditional formatting options (2000 SP1 Win NT4 sp6)

    The method described in <post#= 251962>post 251962</post#> can be adapted to your needs; it will allow as many options as you need. (The example code sets 4 different background colors plus transparent, but it can be used to set font color, font style and borders too, and by adding more Case statements, the number of conditions can be increased.)

  3. #3
    4 Star Lounger pccoyle's Avatar
    Join Date
    Apr 2001
    Location
    Auckland, Auckland, New Zealand
    Posts
    535
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Re: More than 4 conditional formatting options (2000 SP1 Win NT4 sp6)

    I either went to experts exchnage http://www.experts-exchange.com or http://www.ask-a-tech.org/ and obtained a quote to do this (we needed to colour code pressure variances created with people lying on a bed)
    If I recall the cost quoted was reasonable in my opinion, however the project to map the data in Excel was dropped. HTH
    Paul Coyle
    Approach love and cooking with reckless abandon

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Toronto, Ontario
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: More than 4 conditional formatting options (2000 SP1 Win NT4 sp6)

    Thanks HansV and pccoyle: I'll pass this along and will post back with details. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •