Google Spreadsheet Post #1342
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Aug 24, 2013
user Fred Drake (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/dpdvXF7geFY)
Conditional formatting: Testing for a lower-case letter
I have a sheet with alphanumeric codes in one column, where any letters may be upper or lower case, but it's significant which.
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Aug 24, 2013
user Fred Drake (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/dpdvXF7geFY)
Conditional formatting: Testing for a lower-case letter
I have a sheet with alphanumeric codes in one column, where any letters may be upper or lower case, but it's significant which.
When
a cell contains a lower-case letter, I'd like to change to formatting
of the cell. Is there a way to express this without writing 26
formatting rules for "a" - "z"? Can we use regular expressions or
character classes in the test expressions in some way?
Thank you!
---------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment