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
Bookmarks