I'm trying to combine two conditional format concepts I found here.

1. Odd and Even Banding,
2. Hide duplicates values in column.

I can make them work independently, but I have a column where I want to have
the banding taking place and to hide the duplicates. Is there a way to make
both happen?

For the desired cells, I have the Hide duplicates as condition 1, and
Banding as condition 2. When I reversed the, the Banding overroad the Hide
Duplicates. It appears that the first condition met is the one that takes
affect.

Actually, Here's a more detailed description of what I'm doing. I'm trying
to keep track of items purchased, and there can be multiple items per
receipt. I want to make the items that are on one receipt to be 'grouped' or
highlighed so I can see which items were on a particular receipt. I'd like
the grouping/highlighting to be semi automatic, where I don't have to muck
with the format menus and such. Maybe set a char in another column that can
indicate the group?

The Hide duplicates was intended to 'hide' the duplicate purchase date to
show the group.

Any suggestions?

Thanks,
John