Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I want to apply a conditional formating for a row only if the first cell (A column) contains text starting with Volum. Is there a way to do such a thing ? Thanks in advance.
In both examples, Applies To I have set to =$A$1:$J$5
Case Insensitive: =LEFT($A1,5)="Volum"
Case Sensitive: =EXACT(LEFT($A1,5),"Volum")
Required, but never shown