Is it possible?

  • Thread starter Thread starter Amanda
  • Start date Start date
A

Amanda

I am making a worksheet with a drop down option for Disciplinary
Actions....i.e. Oral Reprimand, Written Reprimand, Suspension, Separation for
Cause

Is it possible that if someone selects Suspension, that another box opens
off of it so you can put in the number of days? Or will that have to be done
in a separate cell?

If it does have to be done in a separate cell, how do I do a condition to
lock and unlock the cell based on whether or not they select suspension?

As always, thanks a million!
 
Hi Amanda

A cell to enter the number of days would be ideal. One way is to conditional
format the number of days cell to (grey)..

With Col D with dropdown list and ColE being the number of days.you can have
the below conditional formatting in ColE which will grey out unless the entry
in the corresponding ColD is 'Suspension'
=AND(D1<>"",D1<>"Suspension")

PS:Or else you will have to use a macro..in (WorkSheet_Change event)

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup and Reference (without duplication) 7
Conditional Formatting in subreports 1
Is it possible to protect cell formatting in an unlocked cell? 2
Locked cells are still able to be selected with proper protection 1
Enabling Autofilter and Sorting in a Protected Sheet 2
protect formulas in locked cells from changing if data is moved 3
David Biddulph is correct 8
A form for selecting tables 3

Back
Top