+ Reply to Thread
Results 1 to 2 of 2

More than three conditional formats?

  1. #1
    Registered User
    Join Date
    09-28-2004
    Posts
    16

    More than three conditional formats?

    Does anyone know how to get more than three conditions into the conditional formatting function? I have five conditions I'd like to use.

  2. #2
    Bob Phillips
    Guest

    Re: More than three conditional formats?

    You don't say what your conditions are or what your actions, but here is an
    example of testing for more than 3 conditions and raecting differently

    Private Sub Worksheet_Change(ByVal Target As Range)

    On Error GoTo ws_exit
    Application.EnableEvents = False
    If Not Intersect(Target, Range("H1:H10")) Is Nothing Then
    Select Case Target.Value
    Case 1: MsgBox "case 1"
    Case 2: MsgBox "case 2"
    Case 3: MsgBox "case 3"
    Case 4: MsgBox "case 4"
    Case 5: MsgBox "case 5"
    End Select
    End If

    ws_exit:
    Application.EnableEvents = True
    End Sub

    'This is worksheet event code, which means that it needs to be
    'placed in the appropriate worksheet code module, not a standard
    'code module. To do this, right-click on the sheet tab, select
    'the View Code option from the menu, and paste the code in.


    Post back if you need extra help.

    --
    HTH

    Bob Phillips

    "bludovico" <[email protected]> wrote
    in message news:[email protected]...
    >
    > Does anyone know how to get more than three conditions into the
    > conditional formatting function? I have five conditions I'd like to
    > use.
    >
    >
    > --
    > bludovico
    > ------------------------------------------------------------------------
    > bludovico's Profile:

    http://www.excelforum.com/member.php...o&userid=14805
    > View this thread: http://www.excelforum.com/showthread...hreadid=392620
    >




+ 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