Hi All,

i got the following formula in cell M2.

=IF(L2<>L3,"colour changed from "&L2&" to "&L3,"No change")

im recording a macro and want to drag this down, however since its comparing cells directly below eachother, i want 2 to be identical and then the cell to change.

For exmple, if i drag this formula it will become =IF(L3<>L4,"colour changed from "&L3&" to "&L4,"No change") in M3 and then become =IF(L4<>L5,"colour changed from "&L4&" to "&L5,"No change") in M4.

however i want the cell references to stay the same in M2 and M3, and then M3 and M4, and then M5 and M6. is there anyway of doing this?

Thanks,