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,
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,