Here's a working construct to illustrate:
http://www.savefile.com/files/259026
CF to color rows for identical successive col A values.xls
(with CF dialog screenshot)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---