"Bob Phillips" wrote in message
...
It cannot be fully dynamic Dave as the cell colour change does not trigger
the recalc.

You can make it respond to F9 by adding

Application.Volatile

at the start of the Colorindex function.

--
HTH

Bob Phillips


Ah that's better - ta Bob.