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.

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies