Results 1 to 3 of 3

Conditional Format - Highlight based on the bottom row

Threaded View

  1. #1
    Registered User
    Join Date
    03-17-2008
    Posts
    16

    Conditional Format - Highlight based on the bottom row

    I'm having issues coming up with a conditional format rule that highlights the top cell of a column based on if the bottom cell of that column has the greatest value in it's row.

    This needs to be applied to 13 columns, so I want to highlight the top cell of the column that has the greatest value (based on the bottom row) of the 13 columns. I know I can do this via:

    =AND($J$45>$L$45,$J$45>$M$45, $J$45>$N$45......etc etc applied to the top of the column. However, I would prefer not to do this for 13 columns 13 times. In the interest of expanding my knowledge, I wanted to find a simpler way. I thought of using the MAX function, but the bottom row of the column has formulas that result in a #DIV/0 error. Any way to do this?

    Thanks!
    Last edited by MadCrammer; 08-24-2010 at 01:14 PM.

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