arrange rows and format cell color?

[Rumblebee]

Hi,

I'm not very familiar with vba and excel programming so I need a bit help. I have an excel table with many columns and rows. At each row the is name and numbers ("hits") from 1 to 10 in random ( also empty cells) like so. I would like macro to arrange the rows so that the row with most "hits" to be on top.

Al 1 4 10
Cal 2 3 8
Dee 3 6
DD 2 3 7 9
GE 3 1

I would like macro to arrange the rows so that the row with most "hits" to be on top like this:

DD 2 3 7 9
Al 1 4 10
Cal 2 8
Dee 3 6
GE 3

And also is it possible to for example select cells that have value 3 and make the cell in some specific color??

 

[shades]

Howdy and welcome to the board.

Yes, this can be done. Can you provide a small sample with the layout you are using?

Regarding the coloring, it can be done using Conditional Formatting. Select all the cells, then go to Format > Conditional Formatting. On the left it should read "Cell value is", then in the box just to the right, choose "equal to". There will be one box appear to the right, and type in 3. Click on the Format button, and choose the cell color you want. Click OK, and OK.
________
Toyota Chaser Specifications

 

[Rumblebee]

Hello,

My data looks a bit like this. Unfortunately I can't convert my excel sheet into any good format with this computer but I hope you get the idea. I would like the row that has the most numbers to be on top and so on..

thanks for your help.

View attachment example.txt

 

[rosito]

like this? (but without macro )

 

[Rumblebee]

Yes, like that http://www.access-programmers.co.uk/forums/images/smilies/biggrin.gif
How did you do it

 

[rosito]

for cells: Format-> Conditional formatting...
for column Counter -> use function count...
at last sort by column Counter (descending)
I think it is easy ...not unique

 

[Rumblebee]

Thaks for the help Rosito.