Wednesday, February 27, 2013

yogi_WorkAround For Coloring Cells Of A String (in column B) Red if Number of Characters In String Exceeds Specified Number


                                          Google Spreadsheet   Post  #1053
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 27, 2013
user giathobbits said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/wGCvIHq9x3c)
Color cell if longer than X characters
I want to create a simple spreadsheet to input strings of text.  I would like the cells to turn red if there over 140 characters.  In over my head with scripting and don't even know where to start.
------------------------------------------------------------------------------------------------------------

as of now (Feb-27-2013) Google spreadsheet permits conditionally formatting cells based on values in the cells, this WorkAround colors cells in adjacent column A