Home > OS >  Why does the conditional formatting in this question only apply to a single row?
Why does the conditional formatting in this question only apply to a single row?

Time:05-24

I want to colour row "4" using this custom function "=REGEXMATCH(B4;"Skorpion")" in conditional formatting, but that doesn't work. Only "A4" is blue, and I wanted all row 4 in blue colour.

enter image description here

enter image description here

CodePudding user response:

for a row highlight use:

=REGEXMATCH($B4; "Skorpion")
  • Related