Here's a variation on the same theme. In A1 put the number 1. In A2
=IF(B2<B1,1-A1,A1). For the CF condition, use 0 or 1 and set the format for
those rows.



On Thu, 3 Feb 2005 17:15:01 -0800, "Jim Thomlinson"
wrote:

That is a unique solution that I just had not thought of... Very interesting.
I knew that I hung out in this forum for a reason...

"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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03


----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)

----------------------------------------------------------------------------

"guy" wrote in message
...
I have some product codes in 3 columns that are sorted. I would like to
alternate the color of rows
when a product code changes. How done?