Conditional Formatting Grid vs. Card View

Hi - I tried to set up conditional formatting for a new sheet. I've done this with other sheets with no problem. I want to color by category (entire row). however, the colors are not showing up in Grid view, only Card view.
I have no idea why this is happening. I thought it might be in the settings but it doesn't appear I can edit setting in the sheet.
I've attached screen shots.
Thanks!
Answers
-
Hi
Your conditional formatting has white row backgrounds (grid view) for every condition and colored task bars (card view) that differ for each condition. To achieve what you want, instead of setting Task Bar colors, you should set Background colors. Or you could set both.
When you set up conditional formatting you have two places that you can specify a color (well 3 if you count the text color).
When you change the Task Bar color the conditional formatting row looks like this:
This color will be used in the card view.
If you set the background color, it will look like this:
This will change the background color of the rows in the grid view.
-
Thank you so much! Makes total sense - still a newbie figuring out all the details. Thank you for your help!
-
Great. Glad I could help!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives