I've searched but, can't get the answer is right in front of me. Need VBA code for the following condition:
I have data sheet. The range start from B9 to O1220.
In my data range I applied some condition for formatting row based on cell value.
Now if in the range of this data sheet N9 value is "Yes" then the specific cell H9, K9 & L9 data will be cleared automatically (Cell format will be unchanged)
This rules will be applied in every rows of this data or table range.
Sorry, I am not good at describe words.
Thanks in Advance.
I have data sheet. The range start from B9 to O1220.
In my data range I applied some condition for formatting row based on cell value.
Now if in the range of this data sheet N9 value is "Yes" then the specific cell H9, K9 & L9 data will be cleared automatically (Cell format will be unchanged)
This rules will be applied in every rows of this data or table range.
Sorry, I am not good at describe words.
Thanks in Advance.