How to Disable / Enable specific columns based on the input from a cell

[praveenkagitala]

Hi All,

Attached is the excel sheet which is desiged by me to log my team members daily activity and also use the same for Shift Handover. Colums A to M is used for Daily Tracking.

I am trying to acheive something which I am not familiar of. Trust me I am not good at coding.

Query: I want the columns O to AE be in Disabled (Uneditable) and color coded in "Grey" so that it is understood that it is not editable.

For Ex: In A10 I have an entry and select N10 - Handover Required as "YES" only then the columns O10 to AE10 should be editable. And other columns should be in locked mode for editing.

In the same way if any of the colums under N is selected with Yes, only the same Row should be enabled for editing.

Attached is the excel sheet for better understanding.

Please help me friends