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.