Hi Charlie

FormatConditional FormattingFormula is=$A2<$A1Formatchoose what you
want

--
Regards
Roger Govier

"Charlie Bamford" wrote in
message ...
I have a spreadsheet where column A contains a Product Group and it is
sorted
in this order. Each Product Group may be on several Rows. I'd like to
change the colour of the row when the Product Group changes value. i.e.
similar to formatting alternate Rows but based on the change in value in
Column A...How?