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.

Sorting and coloring cells, formula or macro help needed
 

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.

Sorting and coloring cells, formula or macro help needed
 

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.

Sorting and coloring cells, formula or macro help needed
 

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.

Sorting and coloring cells, formula or macro help needed
 

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.

Sorting and coloring cells, formula or macro help needed
 

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.