Formatting to color code unique differing values?
HI - looking to see if I can alternate color coding of rows using conditional formatting to make it easier to read. For example, the first set of items (sample size) would be gray, then the next white then staffing training back to gray. They are variable numbers and rows can be added to a group at any point
Best Answer
-
Try this:
Insert an auto-number column (called "Auto" in this example). You can have whatever formatting you want/need.
Next insert a text/number column (called "Number" in this example) with the following column formula:
=MATCH(Auto@row, Auto:Auto, 0)
Then you would insert another text/number column (called "Formatting" in this example) with this column formula:
=IF(ISODD(COUNT(DISTINCT(COLLECT([Task Name]:[Task Name], Number:Number, @cell <= Number@row)))), "Gray", "White")
And finally you would set up conditional formatting rules based on this final "Formatting" column.
Answers
-
Try this:
Insert an auto-number column (called "Auto" in this example). You can have whatever formatting you want/need.
Next insert a text/number column (called "Number" in this example) with the following column formula:
=MATCH(Auto@row, Auto:Auto, 0)
Then you would insert another text/number column (called "Formatting" in this example) with this column formula:
=IF(ISODD(COUNT(DISTINCT(COLLECT([Task Name]:[Task Name], Number:Number, @cell <= Number@row)))), "Gray", "White")
And finally you would set up conditional formatting rules based on this final "Formatting" column.
-
Genius!! Thank you so much Paul. Appreciate all you do for this community.
-
Happy to help. 👍️
Help Article Resources
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
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!