Home

Fill color won't work with text in cells of one column only

%3CLINGO-SUB%20id%3D%22lingo-sub-471216%22%20slang%3D%22en-US%22%3EFill%20color%20won't%20work%20with%20text%20in%20cells%20of%20one%20column%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-471216%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys%2C%20its%20seem%20I%20might%20have%20changed%20something%20by%20accident%20while%20working%20on%20an%20Excel%20spreadsheet%20(saved%20as%20an%20'Excel%20Workbook').%20Hoping%20someone%20here%20can%20help.%3C%2FP%3E%3CP%3EFor%20some%20reason%2C%20I'm%20now%20unable%20to%20change%20the%20background%20colour%20using%20'Fill%20Color'%20in%20cells%20that%20have%20text%20in%20them%2C%20but%20only%20in%20one%20column%20(column%20A).%20If%20I%20remove%20the%20text%20from%20these%20cells%2C%20the%20fill%20color%20works%2C%20but%20if%20I%20paste%2Ftype%20the%20text%20back%20in%2C%20the%20color%20disappears%20and%20the%20text%20remains.%3C%2FP%3E%3CP%3EFill%20Color%20works%20on%20cells%20in%20column%20A%20that%20don't%20contain%20text%2C%20and%20also%20works%20in%20cells%20of%20other%20columns%20whether%20they%20have%20text%20in%20them%20or%20not.%20The%20same%20thing%20occurs%20in%20column%20A%20of%20additional%20sheets%20of%20the%20same%20workbook.%3C%2FP%3E%3CP%3EFill%20Color%20works%20fine%20in%20other%20workbooks%20I've%20checked%20since%20this%20issue%20occurred.%3C%2FP%3E%3CP%3EAny%20suggestions%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-471216%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFill%20Color%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
FreddyG73
Occasional Visitor

Hi guys, its seem I might have changed something by accident while working on an Excel spreadsheet (saved as an 'Excel Workbook'). Hoping someone here can help.

For some reason, I'm now unable to change the background colour using 'Fill Color' in cells that have text in them, but only in one column (column A). If I remove the text from these cells, the fill color works, but if I paste/type the text back in, the color disappears and the text remains.

Fill Color works on cells in column A that don't contain text, and also works in cells of other columns whether they have text in them or not. The same thing occurs in column A of additional sheets of the same workbook.

Fill Color works fine in other workbooks I've checked since this issue occurred.

Any suggestions would be greatly appreciated.

Thanks in advance.