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

  • Thread starter Thread starter Rope
  • Start date Start date
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.
 
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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format cell color based on multiple cell values 3
Conditional Format a cell that contains a function 1
Need HELP!! IF OR formula driving me crazy!!!! 8
Conditional Formatting Questions 1
formula explanation 3
Go to next cell if full 5
Excel Macro to automatically go to the right of the last colored cell 0
New Conditional Format Overriding Previous Conditional Format 3

Back
Top