Sorting and coloring cells, formula or macro help needed

I have a problem that i don't know how to solve. I wrote it all in my excel
file that needs to be done.

File is here http://www.sendspace.com/file/q4jc71

Anything that isn't clear, pls ask me. I need this really badly, because my
tables sometimes have thousands of those records.

HTH:
http://excel.tips.net/Pages/T002581_...ged_Cells.html
Micky


"domyrat" wrote:

I have a problem that i don't know how to solve. I wrote it all in my excel
file that needs to be done.

File is here http://www.sendspace.com/file/q4jc71

Anything that isn't clear, pls ask me. I need this really badly, because my
tables sometimes have thousands of those records.

Anyone could help me pls? Its very important for me to have this

"domyrat" wrote:

I have a problem that i don't know how to solve. I wrote it all in my excel
file that needs to be done.

File is here http://www.sendspace.com/file/q4jc71

Anything that isn't clear, pls ask me. I need this really badly, because my
tables sometimes have thousands of those records.

Sorry...
My here above reply was misplaced.
Micky


"domyrat" wrote:

Anyone could help me pls? Its very important for me to have this

"domyrat" wrote:

I have a problem that i don't know how to solve. I wrote it all in my excel
file that needs to be done.

File is here http://www.sendspace.com/file/q4jc71

Anything that isn't clear, pls ask me. I need this really badly, because my
tables sometimes have thousands of those records.

Hello Zagreb, this is Tel-Aviv calling... (-;
I followed your request to color the entire rows even though I don't se a
reason to color 256 cells in one row.
1) Select the range A2:IV40
2) 'Format' 'Conditional Format...' declare 2 Conditions (shown in the
picture) you do not need to declare White because White is your default
background.
*** I'm sure my Hebrew interface will cause no trouble for ou to understand
the procedure ***
http://img179.imageshack.us/img179/3283/nonamej.png
As for the second part of your question - try "Advanced Filter".
Micky


"domyrat" wrote:

Anyone could help me pls? Its very important for me to have this

"domyrat" wrote:

I have a problem that i don't know how to solve. I wrote it all in my excel
file that needs to be done.

File is here http://www.sendspace.com/file/q4jc71

Anything that isn't clear, pls ask me. I need this really badly, because my
tables sometimes have thousands of those records.

Well..., for the second part of your question and only if I understood you
correctly - take a look at the picture.
[I changed the date to 3 days a go in order to present what the results were
on Apr. 1st.]
After having all those TRUE/FALSE you can "Auto-Filter" column E to what
ever you need.
If I misunderstood that part - I'm sure you will be able to adjust the
formula to your needs.
http://img69.imageshack.us/img69/6987/nonameu.png
Micky


"domyrat" wrote:

Anyone could help me pls? Its very important for me to have this

"domyrat" wrote:

I have a problem that i don't know how to solve. I wrote it all in my excel
file that needs to be done.

File is here http://www.sendspace.com/file/q4jc71

Anything that isn't clear, pls ask me. I need this really badly, because my
tables sometimes have thousands of those records.