I have an excel spreadsheet that has thousands of billing line items.
Column A lists the accountnumber and it is ordered by accountnumber.... low to high
so for example..... account 1111 might have 3 rows. one row for each billing line item... ie... phone bill, garbage bill, sewer bill
account 2222 might only have 2 rows... electric bill, garbage bill
i'd like to color the rows with a ledger style row color... by account.
meaning account 1111... its 3 rows would be light green
account 2222's 2 rows would be white
account 3333's rows would revert back to light green.
is there a way to do this. I really don't care what colors they are... just as long as they are light and transparent
attached is a manually created file that looks like what I am talking about. experts-help.xlsx
which makes sense since it is formatting off that data.
is there a way to make the formatting stick and delete the column i am using.