I have just taken over a spreadsheet that has a lot of pretty complicated
formatting on it, the trouble is I know some of it isn't working.

Here is an example:
=IF(M5<"",IF(M5<(J5+0.0104166666666667),TRUE,FALS E),FALSE)

this is applied to a whole column, the trouble is it should really be
checking the value of M# and J# based on the row that the cell is in ie on eg
row 99 it should be:
=IF(M99<"",IF(M99<(J99+0.0104166666666667),TRUE,F ALSE),FALSE).

Is there any way of making conditional formatting formulae relative? (I'm
using 2007, but the spreadsheet will be used on machines using earlier
versions)

Thanks