![]() Type the function above or copy and paste it. Select Use a formula to determine which cells to format. The formula I wrote for COUNTIFS inside on Conditional Formatting is This is the longest method, but a helper column in not required. This 3rd method uses Conditional Formatting with the COUNTIFS function. The two methods I used earier - CONCATENTATE and TEXTJOIN - required a helper column. If the delimiter is an empty text string, this function will effectively concatenate the ranges.Ĭonditional Formatting with COUNTIFS Function ![]() The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined.
0 Comments
Leave a Reply. |