1

I need help highlighting a specific word from G7 to G31. The conditional formatting needs to create a yellow highlight when the First word in the subdivision of rows 7-31 matches the first word of the value in G2 "Nottingham".

Tried to use =$G2="Nottingham" but it is not working...

enter image description here

Also tried =regexmatch(G7,"(?i)^"&regexextract(G$2,"\w")) but this formula is matching too loosely. there sample entries I made are too different than G2 to be considered a close match.

enter image description here

1

1 Answer 1

0

Try this conditional formatting custom formula rule for the range G7:G:

=regexmatch( G7, "(?i)^" & regexextract(G$2, "\w+") )
2
  • Tried to use your formula, however, this formula is matching too loosely. there sample entries I made are too different than G2 to be considered a close match. I've edited my post for the pic
    – Aeri
    Commented Feb 10, 2023 at 22:25
  • Use \w+ instead of \w. Commented Feb 10, 2023 at 22:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.