| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
a formula to "go to" another cell if a condition is true?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
a formula to "go to" another cell if a condition is true?
Is the 9 manually entered or is it the result of a formula?
You can do it the way you want it or you can have the date automatically entered when the condition is met. What date do want to be entered, the current date (today's date) or some other specific date? -- Biff Microsoft Excel MVP "Rope" wrote in message ... 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. |
|
#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. |
| Reply |
| 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 | |||
Linear Mode
