Formatting doesn't work for copied cells
Good afternoon.
Can anyone help me with the following issue?
I have a workplan on a sheet, where I coloured lines, separating sections of the plan, in a grey. Afterwards I copied a formula to all of the cells in a specific column, while the whole column became white (i.e. it changed grey into white in some of the lines).
The problem is that for this column (where I copied formula from one cell to all cells in the column):
1) I cannot change colour of any cell in the column - it's always white. Even if I try Clear Formatting and then apply new colour - it's anyway white. Even if I use Format Painter tool - it copied everything but colour - the cell anyway remains white.
2) Colour coding doesn't work in this cells.
I'm attaching a screenshot, where you can see the column "On track?" which is not editable.Line 39-40 should be grey (I can't change the colour), while line 46 should be green according to the rule (I'm also attaching screenshot of all the colouring rules I have).
Has anyone faced the same annoying issues?
Thank you in advance!
Maxim
Comments
-
Hi Maxim,
Try this:
- Ask all of your colleagues to close the sheet.
- Manually set the color by selecting the cell and then apply the color from the color picker in the toolbar at the top of your sheet. Make sure to save your sheet after applying the color.
If that doesn't work, please reach out to our Support team to troubleshoot this further.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives