Thank you for your responce.

Unfortunately if I add the cell €œC€� it would get confusing for the person
entering the information as they would have to compare it with cell €œA€� and
there are many cells on this page already. If there is a way to put the
formula in cell €œC€� that says if Cell €œB€� is not empty then put an X in cell
€œA€� it would fix my problems. I can not figure out how to this part.

"TomHinkle" wrote:

First off, keep an open mind..

Problem seems to be you want to use A, unless cell B has a value. Add
column C. In column C put a formula using col B if it exists, col A if not.

I KNOW you probably really want to do it in 2 columns.. There's probably a
way, BUT in thinking of maintaining it, if you can do without code, it's
better.

Also, try to avoid worksheets that are used for data entry AND reporting.
Make the data entry sheet simple, and utilitarian. Then make another sheet
that reports the data with all the fancy formatting.



"RB Camp" wrote:

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?