| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
a formula to "go to" another cell if a condition is true?
Formulas can only return results to the cell in which they reside.
To jump to another cell would require event code behind the worksheet. Gord Dibben MS Excel MVP On Thu, 3 Jan 2008 20:05:00 -0800, Rope wrote: If C6="9" I would like cell G44 to get selected to let the data entry person to know that they must enter a date...possible? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Typing "true" excel 2007 change it to "TRUE" | Excel Discussion (Misc queries) | |||
| Can I condition format, "if the cell contains a formula" | Excel Worksheet Functions | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Can you replace "TRUE" with " " in an exact formula? | Excel Worksheet Functions | |||
Threaded Mode
