I'm quite new to excel
so this could be dumb question. I need to change color for those rows which has suffix .com
in their second column. I use OpenOffice
but I can change it using Microsoft Excel
too.
So the thing I want is:
Change a color of the row which second column value match this regex: "./.com" <= This regex
may not be correct.