On Fri, 4 Feb 2005 00:49:58 -0000, "Ken Wright" wrote:

Additional column, assume A.
Assume your data is now in Col B and is sorted on Col B such that changes in
Col B denote required change of colour.
In A2 =--(B2<B1)
In A3 =(B3<B2)+A2 and copy down as far as your data goes

Select the entire sheet, do Format / Conditional Formatting, change cell
value is to Formula is and put in

=MOD($A1,2)=0

Choose a colour from the pattern tab on the format dialog box and hit OK

What if my data is in Col B, Col C and Col D? Changes in either of these denote required change of
colour.

Thank you for your time.