Saturday, August 24, 2013

yogi_WorkAroud For Highlighting A Cell Where The Cell Contains Lowercase Letter(s)

                                          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.

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