VBA selecting top 3

[roberto1111]

Dear Friends,

I'm trying to make a macro that selects the 3 highest values and give these cells a blue backcolor. (The code should skip any blanc cells).


Thanks you for any help offered.

Greetings,

Roberto, The Netherlands

[JBeaucaire]

No macro needed. Use conditional formatting.

1) Remove all the background coloring.
2) Highlight B1:N1
3) Use this conditional format:
Condition1: Formula Is: =AND(B1>0,B1>LARGE($B$1:$N$1,4))
...and set the pattern format to blue.

[roberto1111]

Hello JB,

I've tried to work with Conditional Format but had too much trouble with finding the color numbers for further analysis.

Greetings.

[roberto1111]

......................

[JBeaucaire]

Hello JB,

I've tried to work with Conditional Format but had too much trouble with finding the color numbers for further analysis.

Greetings.

Um...what does that mean?

[roberto1111]

Um...what does that mean?

It means like this;

http://www.cpearson.com/excel/CFColors.htm

[JBeaucaire]

Sounds like you have a path. That's good.

For what it's worth, there's ALWAYS more mathematically logical ways to evaluate data than by coloring. Whatever logic people use to paint and color cells, that same logic can be inserted directly into formulas and analysis...skipping the coloring thing altogether.

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

[roberto1111]

Hello again,

As from one rocket scientist to another, can you advise me what kind of formula I should try to use for this?

Thank you

[roberto1111]

I've tried the conditional formatting with making the highest values bold but can't sort them on this just like I can't sort them on backcolor.

Thank you for any help offered.

[romperstomper]

Since you are looking at the largest values, can't you just sort the data descending? All the largest values will be at the top...

[roberto1111]

Hello RomperStomper,

Sorting the data in descending order is a good alternative.
Only the difficulty for me is that values are inserted to another sheet where they then should be sorted in descending order for further analysis.

I will open a new post on this, thank you for the suggestion.

Greetings,

Roberto