+ Reply to Thread
Results 1 to 7 of 7

Conditional Formatting More Than 3 Conditions

  1. #1
    Registered User
    Join Date
    10-15-2008
    Location
    Montreal
    Posts
    8

    Conditional Formatting More Than 3 Conditions

    Gentlemens ... The Conditionnal Formatting applies only when I have no more than 3 conditions.

    Here's my problem. The cells of the column G in my excel sheet may contain only 5 values: AA, BB, CC, DD, EE, FF.
    Depending on the value recorded in my column G, I want the backcolor of the cell to change. For example, when the value is AA i want the backcolor to be Blue, For BB it will be green, for CC it will be yellow, for DD it will be the Orang, and for EE it will be the Brown.

    I know I must go through the VBA, or I do not know how to do it and where to place the code.

    Can you help me.

    Thank you

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    If you search the forum for conditional formats you'll find many examples of how to do this in VBA.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    re: Conditional Formatting More Than 3 Conditions

    Put this in the module of Sheet 1 (Where Column G is located)
    Please Login or Register  to view this content.
    Looking for great solutions but hate waiting?
    Seach this Forum through Google

    www.Google.com
    (e.g. +multiple +IF site:excelforum.com/excel-general/ )

    www.Google.com
    (e.g. +fill +combobox site:excelforum.com/excel-programming/ )

    Ave,
    Ricardo

  4. #4
    Registered User
    Join Date
    10-15-2008
    Location
    Montreal
    Posts
    8

    Symbols and Conditional Formatting - More Than 3 Conditions

    Thank you Very much for your help guys

    I have now another big concern. In my Column K I have 4 symbols, it's not a simple characters (You can see the image attached to see them)...
    For each of them I want to apply a diffrent backcolor (the same way as it has been done before. I don't know how to refer to these characters
    Attached Images Attached Images

  5. #5
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Turn on the vba recorder and click into the cell then press enter and see what the code gives you

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    You'll need to do something like this:
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    10-15-2008
    Location
    Montreal
    Posts
    8

    Thumbs up Thank you guys

    Thank you guys it works...you guys Rocks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1