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" i...
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.
:-)
Apparently, (written with great humility), I am incapable of creating a formula that CF will accept.
I would ask if you could guide me in this...
The best option here would be to apply a CF that whould highlight column B when there is a date in column D and when the entry in column B is NOT "USED".
Untested.
=AND(D2>0,B2<>"USED")