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

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

--
HTH

Bob Phillips

"Naomi" <[email protected]> wrote in message
news:[email protected]...
> 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

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

--
HTH

Bob Phillips

"Naomi" <[email protected]> wrote in message
news:[email protected]...
> 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

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

--
HTH

Bob Phillips

"Naomi" <[email protected]> wrote in message
news:[email protected]...
> 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

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

--
HTH

Bob Phillips

"Naomi" <[email protected]> wrote in message
news:[email protected]...
> 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

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

--
HTH

Bob Phillips

"Naomi" <[email protected]> wrote in message
news:[email protected]...
> 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

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

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

--
HTH

Bob Phillips

"Naomi" <[email protected]> wrote in message
news:[email protected]...
> 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