Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Highlight Minimum Values In Each Row

1. Senior Member
Join Date
16th June 2010
Posts
142

## 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.

-Kyle

Excel Video Tutorials / Excel Dashboards Reports

2. ## Re: Highlight Minimum Values In Each Row

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

3. Senior Member
Join Date
16th June 2010
Posts
142

## 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. ## 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

5. Senior Member
Join Date
16th June 2010
Posts
142

## Re: Highlight Minimum Values In Each Row

Great Thanks!

Excel Video Tutorials / Excel Dashboards Reports

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

#### 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