Close

Results 1 to 5 of 5
  1. #1
    DF VIP Member Karoline's Avatar
    Join Date
    Dec 2004
    Location
    UK
    Posts
    2,551
    Thanks
    106
    Thanked:        59
    Karma Level
    466

    Help Excel Help - (Formula required)

    Hi, i am looking for a forumula that will highlight cells if it is over a certain amount , i know about the if statement but it will only work with one cell, what i am looking for is this...

    I have a worksheet with this sort of info

    22/7 Annan 10000
    22/7 Dumfries 5120
    22/7 Annan 45800
    23/7 Dumfries 45788
    23/7 Carlisle 124588
    23/7 Glasgow 400001
    24/7 Annan 5200
    24/7 Annan 12000
    24/7 Glasgow 157800

    What i want is to highlight the cells which are equal to or over 10000, however only the Annan ones, and i would like it to highlight not only the number but the whole row with the date and Annan and the number...


    So what i want is somthing like =if c1>=10000 highlight a1:c1 only if a1=Annan
    Sort of thing...

    Is this possible... ???



    (I know it is easier just to highlight the row myself with the red highlighter, but when people who dont know what they are doing are working on the file, they are forgetting that it is an issue and leaving it just normal )

  2. #2
    DF VIP Member Zippeyrude's Avatar
    Join Date
    Dec 2002
    Location
    UK
    Posts
    4,317
    Thanks
    238
    Thanked:        792
    Karma Level
    534

    Default Re: Excel Help - (Formula required)

    In excel

    Tools > Conditional Formatting

    Condition 1

    Drop down to "Formula is"

    the following is the formula:-

    =AND($B6="annan",$C6>10000)

    where column b has the names and c has the values

    press the format button and select the pattern tabto highlight the cell in whatever colour you want etc

  3. #3
    DF VIP Member Zippeyrude's Avatar
    Join Date
    Dec 2002
    Location
    UK
    Posts
    4,317
    Thanks
    238
    Thanked:        792
    Karma Level
    534

    Default Re: Excel Help - (Formula required)

    oh to copy try the format painter

  4. #4
    DF VIP Member BigLarry's Avatar
    Join Date
    Sep 2003
    Location
    Gernston
    Posts
    262
    Thanks
    0
    Thanked:        0
    Karma Level
    269

    Default Re: Excel Help - (Formula required)

    Right click the work sheet, click view code.

    Then add this VBCode.

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Dim rowindex As Integer

    For rowindex = 1 To 10
    If Cells(rowindex, "B").Value = "Annan" And Cells(rowindex, "C").Value >= 10000 Then

    Rows(rowindex).Interior.Color = vbBlue
    Else
    End If
    Next rowindex
    End Sub
    Thoic - The friendly forums.

  5. #5
    DF VIP Member Karoline's Avatar
    Join Date
    Dec 2004
    Location
    UK
    Posts
    2,551
    Thanks
    106
    Thanked:        59
    Karma Level
    466

    Default Re: Excel Help - (Formula required)

    Oh, thanks for the quick response, tested it at home with excel, works great, now to put it to practice at work... Thanks

Similar Threads

  1. IBM T23 – CD-R/RW – Front Panel required
    By afrokiwi in forum PC Hardware
    Replies: 0
    Last Post: 17th September 2002, 06:53 PM
  2. Problem: Help required (tv issue)
    By brumbino in forum Digital Satellite TV
    Replies: 0
    Last Post: 17th September 2002, 01:51 PM
  3. Help building a Formula 1 car body (sort of)
    By bozza in forum Home Audio/Video, Electronic Toys & Gadgets
    Replies: 2
    Last Post: 16th September 2002, 04:05 PM
  4. Formula farce
    By 4me2 in forum General Sports
    Replies: 17
    Last Post: 31st August 2002, 03:31 PM

Social Networking 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
  •