Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Apr 2001
    Location
    Toronto, Ontario, Canada
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBA Conditional Formats for > 3 Conditions (XL97 SR2)

    I have seen a number of posts mentioning that when there are greater than 3 conditions required for conditional formatting, VBA is the way to go. Unfortunately, I can't seem to find any help with how to go about this...

    In the attached example, I am trying to format cells on a schedule whenever any one of a number of 'letter' codes are used (rather than the number value). Resulting in any 'S' showing as bolded red, any 'V' as bolded green etc.I would greatly appreciate it if any one could provide me with an explanation of how to do this.

    Many Thanks for your Time...

    and Happy Holidays!
    Attached Files Attached Files

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA Conditional Formats for > 3 Conditions (XL97 SR2)

    Is this what you want? The code is in the WorkSheet Change event routine.
    Attached Files Attached Files
    Legare Coleman

Posting Permissions

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