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.

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.

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.