1

I frequently use a spreadsheet, onto which we put a table of data.

The data is actually several rows per item we would be dealing with, but the number of rows changes.

For example, several items will all be listed with the same order number. What I then have to do is go through and underline the rows (bottom border) when it changes into a new order.

Is there a more convenient way to highlight a section of the table, then have an entire row formatted with the bottom border everytime a new value is found in a column?

3
  • 2
    Conditional Formatting will do what you want with a formula that compares the cell in the column to the one below it, if they do not match then put the line. May 24, 2017 at 13:46
  • Do you need the formatting change to be permanent (like, if the data is copied elsewhere or broken up)? The solution will vary depending on this. Conditional Formatting, Filtering, Subtotals, or a macro are all possible solutions.
    – Werrf
    May 24, 2017 at 15:40
  • It doesn't havew to do anything complicated, as long as the change in order number is marked by a border the data will just sit there from then on.
    – Duder Guy
    May 25, 2017 at 14:02

0

You must log in to answer this question.

Browse other questions tagged .