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
- Jul 15, 2020Mark 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)
NikolinoDE
Jul 15, 2020Platinum Contributor
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)
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)
- FlutesJul 15, 2020Copper ContributorThat was it, Thanks