Cope and Paste- Cell Color Change
Good afternoon,
Our sheet is now changing cell colors when we copy and paste in it. Why did this happen and how do we make this stop doing this?
Best Answer
-
It may be that there was some manual formatting applied to that top row that isn't visible because of the conditional formatting.
Highlight that entire row and change the cell fill to white. You should not see an immediate difference as the Conditional formatting will still fill those cells with red, but the copy/paste should leave the cell fill alone from there on.
Answers
-
It may be that there was some manual formatting applied to that top row that isn't visible because of the conditional formatting.
Highlight that entire row and change the cell fill to white. You should not see an immediate difference as the Conditional formatting will still fill those cells with red, but the copy/paste should leave the cell fill alone from there on.
-
-
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- Hi Everyone, I would like to create a weekly trivia game for my team members and my thought was to use a form to populate answers to the sheet. However, I don't want them to be able to see what other …
- Good afternoon, In reviewing the question that Nino Chkhikvadze posted on 7/30/20, and the response from Andree Stara, Community Champion, on the same date, would it be accurate to say that an unlicen…
