+ Reply to Thread
Results 1 to 2 of 2

Highlight the maximum value in a row

  1. 03-02-2009, 09:26 AM #1
    abrunstad
    abrunstad is offline
    Registered User
    Join Date
    02-12-2009
    Location
    oslo, Norway
    MS-Off Ver
    Excel 2010
    Posts
    45

    Highlight the maximum value in a row

    Anybody know how i kan make the biggest value in ex. (A1:Z1)
    to be highlighted in the colour red?

    cheers
    Reply With QuoteRegister To Reply
  2. 03-02-2009, 09:31 AM #2
    squiggler47
    squiggler47 is offline
    Valued Forum Contributor squiggler47's Avatar
    Join Date
    02-17-2009
    Location
    Littleborough, UK
    MS-Off Ver
    Excel 3.0 to 2007+2010! (couldnt get 2.1 working)
    Posts
    1,013

    Re: Highlight the maximum value in a row

    use conditional formatting and use =max(a1:z1) as the condition
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1