Worksheet BACKGROUND Colour vs Cell FILL Colour

Hi,

We have a shared workbook in our group at work, that was created on desktop Excel some time ago and is now a live document on a member's OneDrive.
It now gets edited by several people through the webapp 365 interface.
The behaviour below has been observed from before the document was taken live online.

Simply put, cutting and pasting a cell results in the original cell location turning cyan colour, rather than the general white that the rest of the worksheet is.
Seems rivial but when the workaround is to copy the cell instead and then go back to delete the contents of the original, this results in a lot of clicking around.

There doesn't appear to be any conditional formatting in the sheet at all.

I suspected that maybe there is a background colour of the entire worksheet or woorkbook and that the cells are FILLED in white.
However I can't find anywhere to adjust the background colour, or even that such a thing exists seperately to cell fill colours.

I would love the cut cell to simply turn plain white once its contents has been pasted elsewhere.

Any suggestions?

This even stumped ChatGPT :-)

Hi Ali,

Copy rather than cut is the current method, but it takes a lot more clicking around that the task should.
As you can see this is a very simple resoursing allocation schedule and we change it ALL the time, with the move common alteration being a cell moving positions.

There are better ways to track a schedule, but I am not in charge of this sheet nor am I in a position to change solutions.

Given that I am bound to using this for now, I'd rather be able to drag cells around or cut/paste them withough having to go back and reformat the original cell.

PLUS, I don't like not understanding WHY something is happening and it bugs me everytime I use the sheet.

I have attached the offline copy of the workbook here and have confirmed that the behaviour persists in Excel desktop application.

Many thanks,

____________

PS, Happy birthday!
PPS, the Monarch's official birthday here in Australia was Monday 10 June this year.

Hi Ali,

Thanks for taking the time and working through a few things for me there.

The spreadsheet is probably pretty old. More than a few years at least, or has been copied from an old sheet.

Intertesting that an expert is not clear on why this is happening. Somewhat validates my confusion/madness.

I'll ignore my desire to know what is happening and follow your work around.

Thanks again!

Thanks again!

You know I tried simply making a new sheet in the same workbook ONLINE and copying a few columns from the original over to it.
The behavour did not transfer.

Just to check, I copied the entire year of data into the new sheet and PRESTO, no cyan formatting!

I guess that the online 365 Excel app handled the situation differently to your expereince.
In anycase, the issue is gone. Brilliant.