hiding colums using conditional formatting

[robertvdb]

I have a Sheet on which I want to hide specific columns, depending on a specific cell value. See enclosed image.

I know I can do this using VBA, that should be a piece of cake, but since the file will be on SharePoint, I can't use VBA.

Anyone knows how to achieve this through Conditional Formatting ?

Thanks.

 

[Fluff]

You cannot hide columns using conditional formatting. You either need to do it manually, or with code.

 

[Joe4]

You could use Conditional Formatting to "hide" all the entries in that column (i.e. change the font color to white so that it blends in with the background), but not physically hide the column, as Fluff said.

To "hide" the entries in the column, just select columns B:F, and then use the following CF formula:

=B$2="no"

and then choose the white font color for your formatting option.

 

[robertvdb]

Thanks Fluff and Joe4. That SharePoint thing is a pain in the ***, I think. I'll use Joe's solution as a best alternative.

 

[Fluff]

Glad we could help & thanks for the feedback.