Spontaneous Cell Colour and Font Size Changes

chrism.rp

New Member
Joined
Mar 5, 2010
Messages
2
A colleague of mine has an Excel file where the font sizes and background cell colours of individual cells sometimes appear to have changed spontaneously when she re-opens the document.

She had formatted the columns to different colours to indicate what they were being used for (various types of response in an interview). There are no formulae in the document whatsoever, just text. There is no conditional formatting anywhere in the workbook. She is using Office 2007, as is her colleague who also uses the document, but the file is in .xls format. Both users have identical RGB values on their palettes (i.e. the default Office 2007 settings).

When the font size changes, the cell ostensibly remains set to the original font size 11 but all text within the cell has been changed to font size 6. When the cell colour changes, it is to a subtly different shade of the original colour, e.g. the mid-red on their palette to a dark red that is not on their palette.

Obviously, reverting these changes is simple (and we don't need help on that), but it is time-consuming for them to have to check each cell for changes and make any reversions; also, they are worried about the possibility of spontaneous changes after they deliver the document to their client.

Any thoughts on how to prevent this from recurring would be appreciated!
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
still even if u say there is no conditional formating, go to conditional formating and clear rules on entire sheet once. if still it doesn't work upload the file.
 
Upvote 0
still even if u say there is no conditional formating, go to conditional formating and clear rules on entire sheet once. if still it doesn't work upload the file.
No, there really isn't any conditional formatting on it, I've already sorted that. And I can't really upload the file for confidentiality reasons! Anyone got any other ideas?
 
Upvote 0
Why not convert the file to xlsx format. that might help. Also, you might hit ALT+F11 in the document to see the vba editor and make sure there are no workbook open routines which might mess with the fonts.
 
Upvote 0

Forum statistics

Threads
1,213,549
Messages
6,114,261
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top