Here is what I did to solve my problem..
I used this formula at cell sheet2!a1
and copied it to row 250 and then over to column AA
and what it did was say that if the same cell on sheet1 is null then let me
stay null and ifnot then give me it's value and then I created a
conditional format over that entire area saying that if the cell was not
null then give it an outline border and added what ever other formats I
wanted... and it worked...