I have 2 conditional formatting rules in Google sheets that looks for specific counties and applies formatting:
-
=REGEXMATCH($U2, “Brown|Calumet|Chippewa|Clark|Columbia|Dane|Dodge|Door|Dunn|Eau Claire|Fond du Lac|Green|Green Lake|Iowa|Jefferson|Kenosha|Kewaunee|Lake|Milwaukee|Oconto|Outagamie|Ozaukee|Pepin|Racine|Rock|Sauk|Shawano|Trempealeau|Walworth|Washington|Waukesha|Waupaca|Winnebago”) — Applies BOLD
-
=REGEXMATCH($U2, “Kewaunee|Vilas|Adams|Lincoln|Oconto|Juneau|Ashland|Portage|Marathon|Wood|Rock|Waushara|Langlade|Columbia|Richland|Forest|Burnett|Marquette|Crawford|Monroe|Manitowoc|Jefferson|Lafayette|St. Croix|Outagamie|Shawano|Jackson”) — Applies UNDERLINING
The Range for both is the same.
I’ve highlighted the row of interest in blue in the screenshot. As you can see the bolding rule is applied but not the Underlining?
Why not? How can I get both working?