SOLVED

Unwanted fill colors

%3CLINGO-SUB%20id%3D%22lingo-sub-1524964%22%20slang%3D%22en-US%22%3EUnwanted%20fill%20colors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1524964%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20office%20265%20Excel%20I%20copied%20a%20block%20of%20cells%20that%20had%20no%20fill%20colors%20to%20another%20Excel%20spreadsheet%20and%20several%20cells%20ended%20up%20with%20fill%20colors%20that%20I%20cannot%20get%20rid%20of.%20How%20do%20I%20accomplish%20this%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1524964%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1524980%22%20slang%3D%22en-US%22%3ERe%3A%20Unwanted%20fill%20colors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1524980%22%20slang%3D%22en-US%22%3EMark%20the%20cells%20where%20the%20colors%20should%20disappear%3CBR%20%2F%3Eand%20go%20to%20conditional%20formatting.%3CBR%20%2F%3ESteps%3A%3CBR%20%2F%3EGo%20start%3CBR%20%2F%3EStyles%3CBR%20%2F%3EConditional%20formatting%3CBR%20%2F%3EDelete%20rules%3CBR%20%2F%3EDelete%20rules%20in%20selected%20cells.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20it's%20not%20what%20you%20mean%20please%20ignore%20it%2C%20if%20that's%20what%20you%20mean%20I%20would%20be%20happy%20to%20know%20if%20I%20could%20help%20with%20a%20thumbs%20up%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3E%3CBR%20%2F%3ENikolino%3CBR%20%2F%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1525007%22%20slang%3D%22en-US%22%3ERe%3A%20Unwanted%20fill%20colors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1525007%22%20slang%3D%22en-US%22%3EThat%20was%20it%2C%20Thanks%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1525013%22%20slang%3D%22en-US%22%3ERE%3A%20Unwanted%20fill%20colors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1525013%22%20slang%3D%22en-US%22%3Ea%20like%20and%20%2F%20or%20correct%20answer%20also%20makes%20the%20helper%20happy%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20Glad%20I%20was%20allowed%20to%20help%3C%2FLINGO-BODY%3E
New Contributor

In office 265 Excel I copied a block of cells that had no fill colors to another Excel spreadsheet and several cells ended up with fill colors that I cannot get rid of. How do I accomplish this

3 Replies
best response confirmed by Flutes (New Contributor)
Solution
Mark the cells where the colors should disappear
and go to conditional formatting.
Steps:
Go start
Styles
Conditional formatting
Delete rules
Delete rules in selected cells.

If it's not what you mean please ignore it, if that's what you mean I would be happy to know if I could help with a thumbs up

Nikolino
I know I don't know anything (Socrates)
That was it, Thanks
a like and / or correct answer also makes the helper happy Glad I was allowed to help