Forum Discussion
Table Formula Help
I have a Table (obviously), one column (B) is labeled "Status" and is limited to a data validation list; the next column to be considered in this question is column (D) which is labeled "Date Used" into which is to be entered a date.
The problem I am experiencing where a user will enter a date into a row in column D and fail to change the entry in the corresponding row in column B.
EX: Column B entry is currently "UnUsed", the user enters a date in column D then fails to change the entry in column B to "Used" (some other choice that applies).
How can I MAKE the user change the data validation selection in column B once the date is entered into column D?
Thanks in advance for any assistance....
- FORMULA in cell B2
=IF(D2<>"","USED","UNUSED"). Although CF will work it doesn't necessarily means the user will necessarily select the correct option. Automating the column B with a formula, in my opinion will be a better option.
Thank you. Hello Russ
You can set up a data validation in column D so that a date can only be entered the text in column B is not equal to "Unused".
Or you can set up a conditional formatting in column B that highlights the cell if a date is entered in column D.
Never thought of that, was thinking formula of VBA based solution !!! Will try this track right now.... Thanks.
Well, technically you will need a formula for either CF or DV.
:-)
