Simple data formatting problem

Closed
Luki - Jul 21, 2010 at 04:55 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 22, 2010 at 03:07 PM
Hello,

I know I am not a great at excel, ... I know enough to get by, but I wish I knew more.

I'm struggling with one thing recently. Using the good old ways, I named a range of cells "Database" for easier manipulation etc. However, every time I try to "Sort" the data in order to do something with it, and present to my boss, I need reformat all of it.

I use simple formatting for easier following of the data => dotted vertical lines and highlighting every other row. ... as you can imagine the highlighting gets messed up every time.

Any way I can do it automatically?
I tried the conditional formatting, but it forced its own ideas on me, which made it worse.

Please help,

Thanks,
Luki

Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 22, 2010 at 03:07 PM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
0