+ Post New Thread
Results 1 to 4 of 4
Office Software Thread, Conditional Formatting in Technical; Hi, Basicly im trying to create a league table, week 1, 2, 3 etc and then on cell h2 i ...
  1. #1
    stevenwba's Avatar
    Join Date
    Aug 2009
    Location
    Dudley
    Posts
    323
    Thank Post
    110
    Thanked 16 Times in 11 Posts
    Rep Power
    12

    Conditional Formatting

    Hi,

    Basicly im trying to create a league table, week 1, 2, 3 etc and then on cell h2 i have totals, just want a conditional formatting to highlight the whole row of the highest score in the totals, its been a while since ive messed around with excel so hoping someone can help

    Regards

  2. #2

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    6,717
    Thank Post
    1,267
    Thanked 1,639 Times in 1,096 Posts
    Blog Entries
    22
    Rep Power
    504
    Hi Steven,

    What version of office are you using?
    2007 can do this easily via Conditional Formatting -> "Format only top or bottom ranked values"

    Don't think this is in 2003 so we could get more creative if needs be.

  3. Thanks to sparkeh from:

    stevenwba (17th December 2009)

  4. #3

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    6,717
    Thank Post
    1,267
    Thanked 1,639 Times in 1,096 Posts
    Blog Entries
    22
    Rep Power
    504
    Actually 2007 just highlights one cell.
    What I have done to highlight the row is to use the inbuilt function to highlight the correct cell then used another rule for the other cells.

    So for example I have three rows 1, 2, and 3, and three columns A, B and C.
    Data goes in column A and has the inbuilt formula to highlight the highest cell.
    I then use the following conditional formatting formula applied to the remaining cells to highlight the rest of the row

    =$A1=MAX($A$1:$A$3)
    then of course add the correct colour.

    Probably easier of I just sent you the sheet?

  5. Thanks to sparkeh from:

    stevenwba (17th December 2009)

  6. #4
    stevenwba's Avatar
    Join Date
    Aug 2009
    Location
    Dudley
    Posts
    323
    Thank Post
    110
    Thanked 16 Times in 11 Posts
    Rep Power
    12
    PM'd you mate

SHARE:
+ Post New Thread

Similar Threads

  1. [MS Office - 2003] Excel - Conditional Formatting using formula
    By park_bench in forum Office Software
    Replies: 1
    Last Post: 10th June 2009, 02:25 PM
  2. PHP Conditional Replace
    By danIT in forum Coding
    Replies: 5
    Last Post: 19th May 2009, 10:04 PM
  3. [MS Office - 2003] Access - Conditional Macros
    By garethedmondson in forum Office Software
    Replies: 5
    Last Post: 27th January 2009, 12:06 AM
  4. Conditional formatting help needed
    By Jobos in forum How do you do....it?
    Replies: 3
    Last Post: 3rd June 2008, 01:58 PM
  5. Help with conditional formatting
    By randle in forum Windows
    Replies: 3
    Last Post: 25th October 2007, 01:20 PM

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

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