英文:
Google Spreadsheets: Group rows by equal cell and set background color for these rows
问题
Using Google Spreadsheets:我需要按相同单元格值分组行并设置这些行的背景颜色。
我需要交替两种颜色,每次匹配一种。
这里有一个可编辑的电子表格,有真实示例。关键值是列B中的单元格:title (KEY)
可编辑文件: 链接
英文:
Using Google Spreadsheets: I need to Group rows by equal cell value and set background color for these rows.
I need to alternate two color, one for each match.
Here an editable spreadsheet with the real example. The key value is the cell on column B:title (KEY)
Editable file: https://docs.google.com/spreadsheets/d/1klXxhhdgaazGc-secQPZfwdNijLUK6OVOQUxdU-scQU/edit?usp=sharing
答案1
得分: 1
这是翻译好的部分:
Helper Column formula:
=scan(;B2:index(B:B;match(2;1/(A:A<>"";));lambda(a;c;if(c<>offset(c;-1;);a+1;a)))
Conditional formatting custom_formula:
Apply to range: A2:C
=isodd($D2)
=iseven($D2)*len($D2)
英文:
Added solution to your sheet here:
Helper Column formula:
=scan(;B2:index(B:B;match(2;1/(A:A<>"")));lambda(a;c;if(c<>offset(c;-1;);a+1;a)))
Conditional formatting custom_formula:
Apply to range: A2:C
=isodd($D2)
=iseven($D2)*len($D2)
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论