SOLVED

Unwanted fill colors

Copper 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 (Copper 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
1 best response

Accepted Solutions
best response confirmed by Flutes (Copper 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)

View solution in original post