Hey Guys I am trying to show or hide rows in a spreadsheet based on the value in a cell. The range is cells B4:B532, if the cell in column B in any given row in the range has a value of OK i want the entire row to hide but if the cell has a value of ALERT i want the entire row to be seen. Can...