LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
RB Camp
 
Posts: n/a
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
transfering information from one cell to another garr Excel Worksheet Functions 8 February 21st 05 01:28 AM
how do i input customer information and results of meeting frank the tank Excel Worksheet Functions 1 February 16th 05 05:49 PM
store some of the information from one cell into another bsantona Excel Discussion (Misc queries) 1 February 10th 05 02:35 PM
How do I make a cell date specific to input a value on a specific. ebuzz13 Excel Discussion (Misc queries) 1 January 18th 05 05:53 PM
how can i automatically copy the information in one cell on a she. Dan Excel Worksheet Functions 1 November 26th 04 07:03 PM


All times are GMT +1. The time now is 03:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"