Excel if column is hidden a diffrent columns cell equals text -


is there way have cell return value if column hidden,

example - if column "a" hidden cell "b1" equal "text"

place formula in cell b1.

=if(cell("width",a1)=0,"text","") 

Comments

Popular posts from this blog

php - Wordpress website dashboard page or post editor content is not showing but front end data is showing properly -

javascript - Get parameter of GET request -

javascript - Twitter Bootstrap - how to add some more margin between tooltip popup and element -