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?

  • 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. – Scott Craner May 24 '17 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 '17 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 '17 at 14:02

Use conditional formatting with a formula testing whether or not the order number is not equal to previous order number.

Essentially, If order number <> (not equal) to the previous order number, format a top border to the cell, which will give you the desired underline effect.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.