Input cell information
I hope that I can explain this correctly. I have a cell A and cell B.
If cell B is empty I want cell A to be able to have someone type a date
into it. If cell B already has a date, I want cell A to show an X in it
so they know that cell A is not available to be used. I need to do this
without having the formula located in cell A as it gets over written when
someone types in the date. Is there anyway to accomplish this?
|