CODEWITHSUNDEEP
excelexcel-formulahideconditional-formatting
Avi
Avi

Reputation: 2283

Hiding specific rows columns according to specific column

I have the following table:

First Name  Second Name Phone TF
A                B       1     True
A                B       2     False
C                D       3     True
C                D       4     False

I would like to hide column First Name and Second Name only if the value of the TF in the relevant row is False.

The result table would be as followed: 

First Name  Second Name Phone TF
A                B       1     True
                         2     False
C                D       3     True
                         4     False

If there is a wide to hide all TF column it would be good.

Upvotes: 0

Views: 82

Answers (1)

pnuts
pnuts

Reputation: 59450

Assuming First Name is in A1, please select ColumnsA:B and HOME > Styles - Conditional Formatting, New Rule..., Use a formula to determine which cells to format and Format values where this formula is true:: 

=$D1=FALSE

Format..., select Font Color white, OK, OK.

Upvotes: 1

Related Questions