is there a way to hide rows that have a certain character in that row.

example
B1
1
-
-
4
5
The rows with a "-" gets hidden and if the cell gets data other than "-"
later it would unhide the row.

a guy at work said this wasn't possible. without programing. I don't know
that much about VBA. So if that is the only way I guess I will have to learn

Thanks in advance