Hide column if value in row = "x"

[JoshuaSQ]

Hi,

I am looking for a way to hide a column if the value in Row 3 of that column is "x" (x is arbitrary).

It is my intent to normally have most columns hidden. However, columns of interest are revealed by placing an x (or something) on a different sheet which is referenced by Row 3 and column of interest)

See attached

Thanks!

[raehippychick]

Is this any help? I needed to hide a column based on a zero in a cell.... maybe you could adapt it fit your criteria?

http://www.excelforum.com/showthread.php?t=605399

HTH