Home

conditional formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1194460%22%20slang%3D%22en-US%22%3Econditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1194460%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20formula%20or%20conditional%20formatting%20that%20will%20hide%20a%20row%20if%20a%20specific%20cell%20value%20in%20that%20row%26nbsp%3Bis%200%20and%20show%20it%20if%20the%20value%20is%20greater%20than%200%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1194460%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1194506%22%20slang%3D%22en-US%22%3ERe%3A%20conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1194506%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20search%20the%20link%20on%20the%20attached%20picture%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1194654%22%20slang%3D%22en-US%22%3ERe%3A%20conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1194654%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F568048%22%20target%3D%22_blank%22%3E%40tonylinka%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBy%20hide%20the%20row%2C%20I%20presume%20you%20mean%20set%20its%20height%20to%200.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20cannot%20be%20done%20with%20a%20formula%20or%20conditional%20formatting.%26nbsp%3B%20Row%20height%20and%20column%20width%20are%20not%20considered%20%22formatting%22%20in%20the%20sense%20they're%20not%20accessible%20via%20Format%20Cells.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20VBA%20it's%20possible.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Is there a formula or conditional formatting that will hide a row if a specific cell value in that row is 0 and show it if the value is greater than 0?

2 Replies
Highlighted
Hello,

You can search the link on the attached picture
Highlighted

@tonylinka 

By hide the row, I presume you mean set its height to 0.

 

This cannot be done with a formula or conditional formatting.  Row height and column width are not considered "formatting" in the sense they're not accessible via Format Cells.

 

With VBA it's possible.

Related Conversations
Documentation Migration
SunLeo in Office 365 on
0 Replies
Cell Validation - Drop Down Lists and Text Formatting
JenSmith in Excel on
1 Replies
conditional formatting with formula
kdwork in Excel on
3 Replies
Relative conditional formatting
melissach in Excel on
8 Replies