Results 1 to 8 of 8

Conditional Formatting Across Rows

Threaded View

  1. #1
    Registered User
    Join Date
    10-22-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Conditional Formatting Across Rows

    I'm trying to create a sheet that will highlight the highest & lowest value in a row. I have 100 rows with 40 columns. Every odd column is to contain a monetary value and every even column is to contain a rank of the monetary value with the lowest being rank 1 and the highest being rank 20.

    I would like a conditional format that will highlight the highest value (red) and the lowest value (green) in the odd columns of each row.
    (e.g. highlight the highest value per row, ignoring my rank columns inbetween)

    I can get it to do this by selecting each cell on each row along each odd column and setting a top or bottom 1 Conditional Format. I just do want to have to set this 100 times (a total of 200 Conditional formats).

    Does anyone know of a way to either copy the conditional formats so that they repeat by rows (it will repeat by columns if I try the copy + paste formatting function) or is there a one size fits all approach for the range? (e.g. two conditional formats in total that will highlight the highest & lowest values per row ignoring the rank formula columns)

    Untitled.png
    Last edited by Maxymous; 10-22-2012 at 03:16 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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