Just test that cell for a value,
http://www.contextures.com/xlCondFormat01.html
--
__________________________________
HTH
Bob
"Smallweed" wrote in message
...
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?