New answers tagged

0

Conditional formatting rules are evaluated in the order they are shown in the list. The first rule that evaluates to a truthy value sets the format, and further rules are not evaluated after that. This means that you need four custom formula rules: =regexmatch($C2, "Senior") * ($B2="Female") =regexmatch($C2, "Senior") * ($B2=&...


0

The easiest solution would probably be to use a helper column K where the day names are filled down, with this formula in cell K1: =arrayformula( if( row(J1:J) <= max(row(J1:J) * (J1:J <> "")), iferror( vlookup( row(I1:I), if( len(I1:I), { row(I1:I), I1:I } ), 2, true ...


0

I don't think this is something that can be done on Google sheets as of right now. Conditional formatting applies to cells, not text, so attempting to combine different formatting to different texts within a cell would likely need to be manual.


Top 50 recent answers are included