Take a look at http://www.xldynamic.com/source/xld.CF.html

--
HTH

Bob Phillips

"Naomi" wrote in message
...
I'm setting up a worksheet to monitor achievement against targets. I have
seen s similar system used whereby when you enter a value into the
worksheet,
the cell fill colour changes depending on whether the value entered
misses,
meets or exceeds the target value set. Can anyone help me with an
explanation
of how to do this? Thanks