Hide column base on cell value of zero and 1

[niel]

I would like to hide the columns AA to AO using the value of A13 to A217. See link for the file. Please help me, I need this for my job

https://docs.google.com/spreadsheets/d/1myVaKb9Fg6GHqFouLG7RVCs6gKuLgO4D/edit?usp=sharing&ouid=108013102296349492061&rtpof=true&sd=true

[arnelgp]

you can use Conditional Format?

[francilizo]

you can use Conditional Format?

What is conditional format is it a command use in vba iam new in visual basic? Thanks for the reply

[arnelgp]

see sheet1 range aa13-a0217.

goto menu Format Conditional formatting
https://drive.google.com/file/d/1myVaKb9Fg6GHqFouLG7RVCs6gKuLgO4D/view?usp=sharing

[niel]

Thanks Sir I already solve it using VBA