I need help with advanced conditional formatting in google spreadsheets.
I need someone to write a script that checks one column for text=long or short
and color another column green or red
I need a script that checks if a cell contains a colon: and if it does, hide the first 10 characters in that cell.
This is a helpful website that would make this task extremely easy..I'm only not doing it because I'm not versed in programming
[url removed, login to view]