Hi ..

Can someone help please ... struggling

I need conditional format formula which allows me set a colour to the row
on if the cell value in a colume is not the same as the previous cell in
that same colume.
example :-
row 10 col 2 contains 200 no colour change
row 11 col 2 contains 200 no colour change
row 12 col 2 contains 300 change colour of this row to say red
row 13 col 2 contains 300 no colour change
row 14 col 2 contains 300 no colour change
row 15 col 2 contains 325 change colour of this row to red
Thanking you in advance
regards
Norman

--
Message posted via http://www.officekb.com