Hi

Try this. Select A1:E6, then in,

Home | Conditional Formatting | New Rule | Use a formula to determine which cells to format.

Then below white box enter this formula

=SUM(COUNTIF(A1,"*"&TRIM(MID(SUBSTITUTE(TRIM($A1)," ",REPT(" ",99)),ROW(INDIRECT("1:"&LEN(TRIM($A1))-LEN(SUBSTITUTE($A1," ",""))+1))*99-98,99))&"*"))
Choose the format.