I am pretty illiterate when it comes to using Excel. I am currently using it to keep track of my monthly cash spending. My current column headings are:
DATE; CASH SPENT; MILEAGE; ACCOUNT; MONTH. There are many 'duplicate' entries in the CASH SPENT column. I would like to somehow format specific entries in the CASH SPENT column to automatically place the amount of mileage in the MILEAGE column. Is there a way to do this? The row numbers are never the same.

I appreciate any help.

Thanks,
Debi