Underline entire row based on first cell

[JBR9999]

Good afternoon

I am looking to underline a row based on the line item of an order in the first column, so that we can easily see the orders grouped together. Each order may have a different amount of products, and lines can be added or removed. I assume maybe formatting column A to look at the cell above and underlining when it changes, but I wasn't sure how to make that translate the entire length.

Thanks
Brent

[etaf]

use conditional formatting

select the range
A5:S200

and then use the formula
=$A5<>$A6

and format the cell to use border -

[JBR9999]

Perfect. Thank you very much.

[etaf]

your welcome
if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here

[JBR9999]

How do I add solved to the title?

[etaf]

did the instructions in my signature not work ?
If not, then i'm afraid i dont know

If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.