conditional formatting to group rows with repeating entries

  • Thread starter Thread starter Smallweed
  • Start date Start date
S

Smallweed

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?
 
Thanks Bob but there are too many values for that cell to individually
enumerate them in a Cell Value Is statement. What I need is a Formula that
looks at the relevant cells and returns the rows with the same value. I
tried =$B1=$B2 (the cells that match are in the B column) but this misses the
final row of each group.
However, perhaps I'm being too ambitious with conditional formatting....
 
I am not sure I get it, but can't you use

=ISNUMBER(MATCH($B2,{1,2,3,4,5,99,73},0))

changing that array of values to suit
 
Back
Top