Thread: a formula to "go to" another cell if a condition is true?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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 With QuoteReply With Quote