View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Change color of rows every time value in first column changes

Example of layout

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Natasha" wrote in message
...
Hi,
I am using Excel 2003.
I have a spreadsheet with one-to-many relationship data. First column
contains plot numbers that repeat if more than one species of plants were
found at that plot, i.e. plot number can be repeated an unspecified number
of
times. I am trying perform a function that is similar to highlighting
every
other row, except I would like to highlight every other plot. Thanks!