Hide column on condition base

HELLO excel friends............

my problem is to hide the entire column on a cell base value:-
for example:-
i am uploading a Test file.........
in my Test File, it contains two sheets i.e. "Master" and "D.D. List"
is it possible to hide the "AV" and "AW" column when i select "CUSTOM" in AP14 which is exist in Master Sheet without any help of insert a Commandbutton

Thats it

Hi

Whilst it is not possible to hide the column by setting a new Conditional Rule you can make the cells invisible.

The new rule on the Master Sheet is :-Set the formula when AV14 ="Custom" Format is equal to the background colour Grey to apply to the range AV 24 to AW90.

I have not gone into detail how to set conditional formats as several already exist.

Cheers

Thanks 4 reply..... I want to do this with the help of macro code Without commandbutton....... Conditional formatting is not my concern....... Hope you will understand

Hi
Totally understand but what do you want to trigger the macro. Do you want to run it every time a selection is made on AP14 i.e. when a selection is made the macro will test for "CUSTOM" and hide AW and AV columns or do you want it to run on demand. Either way it will slow your worksheet but not to be noticeable.
Cheers

Hey thanks 4 reply...... I want when I select CUSTOM from drop down list then macro run otherwise not run............