Saturday, September 14, 2013

yogi_WorkAround For Conditional Formatting For A Range Of Cells Based On Number Of Comma Separated Items In A Cell

                                          Google Spreadsheet   Post  #1367
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep 10, 2013
user Aram Donabedian (http://productforums.google.com/forum/?zx=12tctimpyndk#!mydiscussions/docs/x0kQMy_tOeI)
Using Conditional Formatting with Commas
I was wondering if there was a way to assign conditional formatting based on the number of comma separators in a cell?  IE: A,=green B,C,=Blue D,E,F,=Yellow

The letter values won't always be fixed and will be different from cell to cell so I want the number of commas in the cell to be the condition.

Can I do that?

Thanks

---------------------------------------------------------------------------------------------------------------------------------------------------