conditional formatting more than 3 conditions
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: conditional formatting more than 3 conditions

  1. #1
    Guest

    Default

     
    I have column A conditional formatted as =D1=1, but I need to be able to compare it to 10 different number in D1, how can this be done, I am using excel '97. thanks

  2. #2
    Guest

    Default

    what are the 10 different numbers?

  3. #3
    Guest

    Default

    1-10, 1,2,3,4,5,6,7,8,9,10,

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Guderup, Denmark
    Posts
    288
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    insert this in conditions
    =AND(D1>=1;D1<=10)

  5. #5
    Guest

    Default

    I need different conditions for each number

  6. #6
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You will need VBA for more than Three conditions. I seem to recall that Dave Hawley had some code for this on his web site at OZGRID.com

  7. #7
    Guest

    Default

    looked on OZGRID.com can't find it

  8. #8
    Board Regular
    Join Date
    Feb 2002
    Location
    Guderup, Denmark
    Posts
    288
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Do you want the whole column to change color when D1 changes or do you want
    A1 to change when D1 changes
    A2 to change when D2 changes
    and so on

  9. #9
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    Ok i do not like to post my VBA Scripted codes as most dont understand my odfd programming, However this i have developwed over time, to colour the whole row which i wanted subject to Col m anywher reading K, thisits does FAST!

    I owe Dave Hawley a big ti[p of the hat as really he set the seeds on this one and this is his style of programming, it never fails me, i use this bit MUCH bigger 25 conditions not just row colour easy to convert or edit to WHATEVER.

    Everopne will what this its that goos just add section but section to add conditions as you like,

    Cheers Dave Hawley http://www.ozgrid.com

    .........
    Sub Rows_Color()
    On Error GoTo Z
    Sheets("Sheet1").Select
    Range("A1:R500").Select
    Selection.Interior.ColorIndex = xlNone
    Range("A1").Select
    Application.ScreenUpdating = False
    Rw = 1
    '>>>>>>>>>>>>>>>>>>>>
    With Sheets("Sheet1") 'Jack in the UK
    For K = 1 To WorksheetFunction.CountIf(.Columns("M:M"), "K")
    Set RKateFoundCell = .Columns("M:M").Find(What:="K", _
    After:=.Cells(Rw, 13))
    RKFoundCell.EntireRow.Interior.ColorIndex = 4
    Rw = RKFoundCell.Row
    Next K
    End With
    '>>>>>>>>>>>>>>>>>>>>>

    '>>>>>>>>>>>>>>>>>>>>>
    Columns("R:IV").Select
    Selection.Interior.ColorIndex = xlNone

    Application.Goto Reference:="R1C14"
    Application.ScreenUpdating = True
    Z:
    End Sub
    ..............

    These is the base to any conditional format problems !






    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  10. #10
    Guest

    Default

      
    Tommy i need
    A1 to change when D1 changes
    A2 to change when D2 changes
    and so on
    Thanks

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com