Excel - Copying formula down selected cells

usmanhussain13

New member
Joined
Jan 29, 2019
Messages
3
Reaction score
0
Points
0
Excel Version(s)
2010
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,
 
Back
Top