What form does your Bill_IDs take? Are they simple numbers, or
mixtures of alpha and numeric? Will the rows for one Bill_ID be
consecutive?

In Excel 2003 and earlier you can only have 3 conditional formats
(plus normal format) in one cell, so you would need to "transform" the
Bill_ID to 1 of 4 values maximum. This can be done numerically if the
IDs are numbers, or via a lookup table of unique IDs if they are text
values. Post back with the answers to the questions if you need
further guidance.

Hope this helps.

Pete

On Oct 29, 4:01 pm, "Bob" wrote:
Using Excel 2007. I have a workbook with 40,000 rows of data. Each row is
a set of data for a Bill_ID. There are several thousand Bill_ID's and the
number of rows associated with each Bill_ID varies. So, one Bill_ID may be
comprised of 6 rows, the next Bill_ID has 20 rows, etc. I'd like to
conditional format every other Bill_ID for easier identification / viewing.
Any suggestions? Thanks for your assistance.