Wednesday, July 25, 2018

yogi_Conditionally Format By Date Groups With A Blank Line Between Date Groups

Google Spreadsheet   Post  #2479

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jul-25-2018

question by: guyute!topic/docs/9bJSSRpGbvY;context-place=forum/docs
How do I automatically sort by 3 sequential columns and add a colored dividing line?
I would like to automatically sort by 3 fields sequentially so that I don't have to highlight everything, then click data>sort range each time.

1. How can I have it automatically sort by multiple columns? First by date (column B), then by location (column I), then by time (column c)?
2. Also, I would like to have a colored line (bottom of rows 31, 32 and 39) dividing the different dates. If a colored line isn't possible, then an empty row.

Here is the link to the spreadsheet:

The sheet is called "example 2 for totals"
The tab is called "autosort".

The top part of the table shows the data unsorted.
The lower part of the table shows it sorted with the horizontal line dividers in it.