Why is the column not shaded like the others?
Hello,
I am making a survey template to send forms(surveys) to others and will autofill responses in the sheet. I have formulas in that columns all are working perfectly but I cannot figure out why this column is not shaded like the others. It has a column formula and is locked like the others. Any ideas?
Column in question is (Converted) Overall 1
Best Answer
-
It looks like your column colors are set manually, so you could simply change the color of that column by selecting the column, going to the Background Color icon in the top menu, and changing the color. Alternatively, if you're using conditional formatting, then perhaps your rules need adjusting.
Hope this helps!
Answers
-
It looks like your column colors are set manually, so you could simply change the color of that column by selecting the column, going to the Background Color icon in the top menu, and changing the color. Alternatively, if you're using conditional formatting, then perhaps your rules need adjusting.
Hope this helps!
-
Thank you Kelly - I did end up deleting the conditional formatting and changed the cell to grey. It still looked different but I ended up deleting the sheet and starting over new and now it is fine.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!