PDA

View Full Version : HIDE COLUMN BASE ON CELL VALUE OF ZERO AND 1



niel
08-05-2021, 07:32 AM
I WOULD LIKE TO HIDE THE COLUMN 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
08-05-2021, 07:44 AM
you can use Conditional Format?

francilizo
08-05-2021, 08:45 AM
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
08-05-2021, 06:25 PM
see sheet1 range aa13-a0217.

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

niel
08-22-2021, 12:43 AM
THANKS SIR I ALLREDY SOLVE IT USE VBA