View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Smallweed Smallweed is offline
external usenet poster
 
Posts: 133
Default conditional formatting to group rows with repeating entries

I've got a big list of records which I would like to group into visible
sections by colour according to a field, i.e. all rows with the same value in
that field show in yellow, the next "group" showing without a background
colour, then the next group in yellow again and so on- basically, a variation
on the alternating coloured rows you can do with a MOD(ROW) formula.

Does anyone know a conditional formatting formula solution to this?