Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
up to 7 functions? | Excel Worksheet Functions | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
Trying to add conditional formatting to every other cell...GOING . | Excel Worksheet Functions | |||
Possible? formula in one cell can fill another cell | Excel Worksheet Functions | |||
Conditional formatting row if cell value in certain column is even | Excel Worksheet Functions |