How can I hide 1 or more columns based on a cells value
For example,
If there is an X in cell A1, column F will be hidden.
If there is an X in cell A2, column F will be visible.

If there is an X in cell A3, column G will be hidden.
If there is an X in cell A4, column G will be visible.

This could be triggered by a macro.

I am using Autofilter for rows

I am using Excel 97.

Art