Theme Colours changing for no reason?

[DebbieT69]

Attached doc shows how we record info for budgeting purposes so that we can check progress, chase suppliers/procurement etc.

as these progress we change colour - red for any issues, amber for passing first part of procurement process and green once confirmed paid.

for the past 6 months or more some of these have shown yellow - not a colour we've ever used!

I have changed them individually to green and saved the document straight away but going back in later they have reverted to yellow

Any idea what is going on here? I've copied the previous tax year's to use for the current year and don't want the error to have been copied with it


I fully expect this to be something really simple/daft as usually after I post on the Forum I figure out my obvious mistake....

Thanks in advance

[Special-K]

No attachment.

Attach a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.

[DebbieT69]

d'oh hadn't even tried, too many windows open

now attached to op

[Special-K]

Spreadsheet is password protected

[leelnich]

Hi Debbie- Your attached workbook is PASSWORD-PROTECTED. Please try again.

[DebbieT69]

oh poop

[DebbieT69]

password is EQUALITIES2016

[Special-K]

There is no Condtional Formatting
There are no macros.

So the yellow has been coloured manually, perhaps another user of the file saving the wrong colour.

I changed yellow to green, saved the file and it opened up as green.
Works for me.

[DebbieT69]

I've done same and it changes back... when I open it straight after saving it seems fine, next day or so it's back to yellow

I do work with a nutcase who is capable of changing them to yellow manually just to try to drive me insane but I'm trying to rule that out as a possibility here

I'll have a look at the conditional formatting and macros - not something I use, we just cobble together basic spreadsheets on an ad hoc basis depending on the jobs, never anything fancy

[Special-K]

When you change it, take a copy of the file.
When it turns yellow next, compare the Windows dates against each file.
I suspect the dates will be different suggesting someone else has done this manually...

...or that you may be schizophrenic!

[DebbieT69]

thanks, will try that

not sure if schizophrenia would be better or worse than have a colleague doing it out of spite/for fun


she once collected all the staplers from the office and stashed them in her top drawer then pretended she couldn't hear me when I asked if she'd seen my stapler

It wasn't a red stapler

but it was my stapler

[Special-K]

Perhaps she'd stapled her ears shut?

[DebbieT69]

Changed colour, saved it then saved as a different name

original is still yellow, saved as has accepted changes to green

dates and times are 1 minute apart i.e. the time between me saving then Save As so nobody else has been tampering with it

at least I know the copy I made should be ok, I can Save As to check and delete the copied one if it's not working but still a mystery as to why it doesn't save

[Winon]

Hi DebbieT69,

Has your problem been resolved?

Regards.

[DebbieT69]

yes and no

no idea why it's happening but I know how to get around it!

I'll close the thread