So did Zarrar ever resolve her problem? I guess not. Seems MS has changed the
behaviour of Excel 2007 so that selected cells do not change colour. Which is
very annoying, particularly in discontinuous ranges. I would dearly like a
fix.