I had a formula made by @rockinfreakshow to fill background colour in cells depending on minutes added after a teacher's name but something happened and extra cell is coloured.
45 means 45 min so it should be only 2 cells coloured in green.
Here is the formula.
=index(let(Σ,xlookup(1,--regexmatch(B$2:B2," \d+$"),B$2:B2,,,-1),xmatch(cell("address",B2),address(row(Σ)+sequence(choosecols(split(Σ," "),-1)/15,1,0),column(Σ)))))
发布者:admin,转转请注明出处:http://www.yc00.com/questions/1743735298a4498147.html
评论列表(0条)