I am creating an ongoing list with Column B=Item, Column C=Cost, Column D=Running Total. The problem is, some of the items are lumped together (3 items all bought together only have 1 cost, etc.) This means that column D has a lot of repeated numbers. I'm hoping that there is a way to do conditional formatting so that the repeats don't appear in my running total column.

Currently, my running total formula is D2=SUM(C2+D3) [Newest items are at the top, so the running total adds the new cost to the running total in the cell below it.]

Any help would be appreciated!