Any way to auto-hide rows without using VBA? Conditional formatting?

[jscranton]

I know how to hide rows using a Worksheet_Change module. But, the end user is worried about the workbook being file type xlsm.

So, looking to avoid a macro solution if at all possible.

Bottom line ask: user fills in Cell a13 with a certain value. Based on the value in Cell A13, if the value in $A17:$A25 matches, I want it to be visible/unhidden. Otherwise, it should be hidden.

 

[Joe4]

Conditional Formatting can make the text of the lines appear to be invisible (by making them the same color as the background), but it cannot hide rows.
The only other way I know of automatically hiding rows without using VBA is to use Filters. But that could be a bit tricky if you are only trying to apply this to a subset of your entire data list.
See here: https://www.extendoffice.com/documents/excel/3186-excel-filter-rows-by-list.html

 

[storm8]

I don't think that's possible without vba. the file would have to be xlsm