Sorting and coloring cells, formula or macro help needed

  • Thread starter Thread starter domyrat
  • Start date Start date
D

domyrat

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
 
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
 
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
 
Back
Top