Please help:

I have a spreadsheet that has site numbers listed in the far left column, then there are 8 columns to the right. Each of the 8 columns represents a Visit # and the cell is filled in with the date, like so:

Site # Visit 1 Visit 2 Visit 3 Visit 4
1001 08/20/08 LATE! 10/31/08 LATE!
1002 04/21/08 05/16/08 LATE! 07/21/08
1003 LATE! 02/21/08 03/15/08 LATE!

I need a formula that will look in each of the cells and if it finds a "LATE!" , it places an X in the cell, if not, it places a blank or a zero. I had the formula as:

=if(b1:b4="LATE!","X",0)

It keeps returning an error because it is calculating the total of all of the cells instead of looking into each cell. I tried to spell it out like:

=if(b1,b2,b3,b4="LATE!","X",0)

That didn't work either. HELP!