Open office calc problem

[ste1200]

Hi, I have been working with an inventory CSV file in open office calc. I have been copying rows from it and inserting them in to a new inventory CSV file. So I knew which rows I had done, I filled the cells with a colour. I have just saved a backup of the original inventory file and then closed it and gone back in to the original file but all the colours have gone ! I have opened up the backup file and again all the colours have gone too. So now I don't know which ones I have copied. Is there a better way to do this ?

Hope this makes sense.

Thanks in advance.
Ste

[shg]

CSV files are text files; they don't store any formatting.

Excel would warn you that the formatting will not be saved; I have no idea what OO does.