View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob[_12_] Bob[_12_] is offline
external usenet poster
 
Posts: 7
Default Conditinal Format

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.