Restrict entry on certain cells based on multiple drop drop-down list

[Vani11]

Hi There!

I have been working on excel codes to restrict specific cells based on values from multiple drop-down list.

[TABLE="width: 495"]
<tbody>[TR]
[TD]Subject Name[/TD]
[TD]Type[/TD]
[TD]Status[/TD]
[TD]Appointment[/TD]
[TD] ID[/TD]
[TD]Time[/TD]
[/TR]
[TR]
[TD]Test Subject 1[/TD]
[TD]HV[/TD]
[TD][/TD]
[TD][/TD]
[TD] 15033[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Test Subject 2[/TD]
[TD]DM[/TD]
[TD][/TD]
[TD][/TD]
[TD] 13588[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Test Subject 3[/TD]
[TD]DM[/TD]
[TD][/TD]
[TD][/TD]
[TD] 82215[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Test Subject 4[/TD]
[TD]RP DM/HV[/TD]
[TD]New[/TD]
[TD]Confirmed[/TD]
[TD] 15632[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Test Subject 5[/TD]
[TD]HV[/TD]
[TD]New[/TD]
[TD]Rescheduled[/TD]
[TD] 15643[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Columns, "Type", "Status", "Appointment" have drop-down list menu.

When the user selected the values from the "Type" column, the cells from the "Time" will have to be disabled.

When the user selects, "DM" or "HV", the cells under the "Time" must be disabled.

The cells under the "Time" will only be enabled if the user selects "RP DM/HV".

I find this quite tedious because there will be multiple drop down list throughout the spreadsheet.

Vani

 

[My Aswer Is This]

You said:
"I have been working on excel codes to restrict specific cells based on values from multiple drop-down list."

Show us the code you have written.

 

[Vani11]

Hi There!

I did used codes but have removed it from the code page.

Tried using Conditional Formatting but it does not work.

 

[istiasztalos]

Hi,

What did you try as conditional formatting? That should work, select Time column set font to white to make it invisible, add conditional formatting with formula.

Use this formula =B2="RP DM/HV" and make it change the font to black. (when applied to multiple cells B2 is treated as a relative reference, it will check column B in the relevant row)

 

[Vani11]

Hi,

Would there be a way to link a dropdown list value to a user form? The appointment column "D" has drop-down list.

The drop-down list values are:
Confirmed
Rescheduled
Cancelled

If a user selects, "Rescheduled", a pop up form should appear to users to select the following checkboxes:

*Blood Test *Urinalysis * Blood Pressure

Next, when the user mouse over that row of data where the appointment is "rescheduled", it should show the checkbox which the user have selected.

[TABLE="class: cms_table_cms_table_grid, width: 486"]
<tbody>[TR]
[TD]Subject Name[/TD]
[TD]Type[/TD]
[TD]Res[/TD]
[TD]Appointment[/TD]
[TD]ID[/TD]
[TD]Time[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]DM New[/TD]
[TD]0.30[/TD]
[TD]Confirmed[/TD]
[TD]15605[/TD]
[TD]8:45 AM[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]0.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]0.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]0.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]0.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]0.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]0.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]0.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]