I have a spreadsheet that tracks time sheet information.
I have a cell (A2) that has a drop down list with 2 options- "Tardy" OR
"On-Time". I want to be able to make cell A3 mandatory that you fill in
how many minutes the person was late if A2 is = "Tardy".
So If A2 = "Tardy"
Then A3 Is required
Else
Do Nothing.

Can this be done?

Thanks for any direction!


--
jprogrammer
------------------------------------------------------------------------
jprogrammer's Profile: http://www.excelforum.com/member.php...o&userid=29781
View this thread: http://www.excelforum.com/showthread...hreadid=513772