Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula to differenciate whether a cell contains a funtion or numb
I wish to change the formating of a cell depending on whether it's containts
are a number which is: a) from reference to another cell on another sheet worksheet or b) directly entered by the user and typed over the formula The application is a time sheet where the "planned/forcast number" is supplied and and the user updates as they progress by over writing with actuals numbers. I would like to have the backgound cell colour change depending on whether the value is forcast or actual. Any suggestions? Cormac. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using contents of a cell in a formula | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
looking for a formula | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |