How do I set up conditional cell fill colours in Excel?

[Guest]

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

 

[Bob Phillips]

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