Simple data formatting problem

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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