Ok, found a an answer to my own question here. I just really can't be that easy. The developers of FMP seem to have really thought of just about everything, it just blows me away. So here is a real simple solution to my original post for those that might end up looking for this in the future. I almost made this much more complicated than I would have needed too.
In the conditional formatting formula on the field you want to be highlighted -> GetNthRecord ( TABLE::FIELD_NAME ; Get ( RecordNumber ) - 1 ) ≠ TABLE::FIELD_NAME
Hope this helps someone else.