I'm using Open Office and some of the cells have suddenly gone turquoise and I don't think I've done anything! Anyone have any ideas of what's going on? I've tried setting the fill to white but these don't change.
Which cells are affected? Are they in specifics rows or columns, are they in blocks or are they just dotted around randomly? Is it just one spreadsheet that's affected or is the blank one you first see when creating a new document likewise affected?
I seem to have solved it by highlighting the whole sheet, right clicking and going for default formatting but I still don't know what I did to cause it! If I copied a bit of the coloured text into another part of the sheet the colour appeared. I'll keep my fingers crossed that whatever I did I don't do again/