a formula to "go to" another cell if a condition is true?

R

Rope

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.
 
T

T. Valko

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?
 
G

Gord Dibben

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
 
Top