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

--
HTH

Bob Phillips

"Naomi" <Naomi@discussions.microsoft.com> wrote in message
news:22E47FB5-F3B7-4FDC-9B05-F2D5FFD05B13@microsoft.com...
> 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