Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Highlight Minimum Values In Each Row

  1. #1
    Join Date
    16th June 2010
    Posts
    140

    Highlight Minimum Values In Each Row

    Hello All,

    I am new to the forums, and somewhat new to using VBA.

    What I would like to do: On sheets "TeamAvg" and "IndividualAvg" with given data in B3:K118, I need help creating a macro that will highlight(format the color/style) the cell containing the minimum value for each row of data(rows 3-118). Some rows are likely to have blank cells, and some rows may have two cells of the same value which happen to be the minimum value(s).

    The data in the range of B3:K118 is constantly being updated through another macro I created to input averages. I just need the minimum value of the averages in each row highlighted.

    Any help/suggestions is greatly appreciated.

    Thanks in advance!

    -Kyle

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    19th January 2007
    Location
    South Carolina, USA
    Posts
    9,206

    Re: Highlight Minimum Values In Each Row

    Why can't you use Conditional Formatting for this, using the formula option?
    AAE
    ----------------------------------------------------

    Forum Rules | Message to Cross Posters | How to use Tags

  3. #3
    Join Date
    16th June 2010
    Posts
    140

    Re: Highlight Minimum Values In Each Row

    I didn't know that's what conditional formatting did, sorry my mistake, but what should the Formula be get the result I want?

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    19th January 2007
    Location
    South Carolina, USA
    Posts
    9,206

    Re: Highlight Minimum Values In Each Row

    The formula might be: =A3=MIN($A3:$J3)

    You didn't specify how many columns your row spans so adjust the formula as needed.

    To apply the CF:
    Beginning with the first celll ont he row (say A3), select all cells on the row, then invoke the CF dialog box and select the formula option.

    After entering the formula and specifying the format options for the conditon, close the CF dialog, then copy and pastespecial (format) the row to which you just applied the CF. You can also use the Format Painter to do this.


    Conditional Formatting
    AAE
    ----------------------------------------------------

    Forum Rules | Message to Cross Posters | How to use Tags

  5. #5
    Join Date
    16th June 2010
    Posts
    140

    Re: Highlight Minimum Values In Each Row

    Great Thanks!

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Maximum & Minimum Axis Values From Chart
    By fluff in forum EXCEL HELP
    Replies: 9
    Last Post: November 25th, 2009, 21:58
  2. Find 2 Corresponding Values & Multiple The Minimum
    By kathyb0527 in forum EXCEL HELP
    Replies: 6
    Last Post: January 11th, 2008, 08:06
  3. Lookup Minimum Values
    By saotei in forum EXCEL HELP
    Replies: 7
    Last Post: July 7th, 2007, 15:52
  4. Copy Values Between Minimum & Maximum
    By Grumble in forum EXCEL HELP
    Replies: 5
    Last Post: July 6th, 2007, 00:52
  5. Exclude Minimum Two Values In Average
    By aubie8 in forum EXCEL HELP
    Replies: 3
    Last Post: December 8th, 2006, 05:04

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
  •  
porno