Google Spreadsheet Post #1367
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Sep 10, 2013
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
---------------------------------------------------------------------------------------------------------------------------------------------------
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
---------------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment