Hello,

Is it possible to format a table either of these ways? One would involve conditional formatting where it highlights a certain color when it detects a change in a cell. The preferable option would be the screenshot where there are spaces between to separate each new supplier/seller to make the sheet easier to read. Are either of these possible to do?

example 1.PNG
example 2.PNG