reza_doang
12-16-2018, 10:45 PM
Hi -
Currently i have wide sheet from Col A to AL, inside that table i put some conditional formatting.
let say in column H, the user need to fill yes or no. and if they put Yes, column I, J and L the cells will be marked as Red which indicates they need to fill with some answer.
and if they put No (in column H), column I, J and L the cells will be mark with Gray which indicates they no need to fill anything.
now what i want to achieve, if the user fill with "No", column I, J and L the cell will be grayed and cell will be locked. while if the user fill with "Yes", they need to fill in red
is that possible using macro?
thanks in advance
Currently i have wide sheet from Col A to AL, inside that table i put some conditional formatting.
let say in column H, the user need to fill yes or no. and if they put Yes, column I, J and L the cells will be marked as Red which indicates they need to fill with some answer.
and if they put No (in column H), column I, J and L the cells will be mark with Gray which indicates they no need to fill anything.
now what i want to achieve, if the user fill with "No", column I, J and L the cell will be grayed and cell will be locked. while if the user fill with "Yes", they need to fill in red
is that possible using macro?
thanks in advance