Forum Discussion
Excel autohide row based on 4 cells if blank
Hello. I am looking to autohide a row if four columns are blank.. Is this easy to do?
This would require VBA, so it will only work in the desktop version of Excel for Windows and Mac.
If that is OK, please provide more detailed information.
If Low Low Alarm, Low Alarm, High Alarm, and High High Alarm is not a number, then hide the row
If for example Low Low Alarm has 0 or another number then the row must be seen
The column can be !!! or blank, for it to be visble at least one number muct be present in one or more of the four columns
Thanks for your reply