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. Problem: conditional formatting in excel 2010 multiple conditions. conditional formatting in excel 2010 multiple conditions. This 3rd method uses Conditional Formatting with the COUNTIFS function. Problem: Is there any way around this : Excel conditional formatting highlight row if cell contains text asked Jun 20 Mezbah 183k points. 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.
