VBA to show/hide rows

[stephen.smith]

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 anyone help with code to do this.
Thanks in advance
Stephen

 

[SteveO59L]

For your info

To Excel

Ok OK and ok

are all different

be careful of which case you use

 

[stephen.smith]

Thanks that was what I was doing wrong. I hadnt got the OK put in correctly.
Thanks so much, really appreciate it.
Thanks
Stephen