Forum Discussion
Flutes
Jul 15, 2020Copper Contributor
Unwanted fill colors
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
- 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)
3 Replies
- NikolinoDEPlatinum Contributora like and / or correct answer also makes the helper happy π Glad I was allowed to help
- NikolinoDEPlatinum ContributorMark 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)- FlutesCopper ContributorThat was it, Thanks