Sunday, January 5, 2014

yogi_Apply Conditional Formatting Using Google New Sheets To Cells D5 to D Valid Entries As Listed In H5 to H And 'Income'

                                          Google Spreadsheet   Post  #1474
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jan-05-2014
question by curtisblackwell (!mydiscussions/docs/3jkaHv6R-mM)
Is there a way to have multiple data validation rules or to mimic "List from a range?"
I'm currently using the "List from a range" option to validate a column. However, there's one valid string that isn't in that range, and adding it to that range would disrupt the flow.

Is there a way to setup multiple validation rules? If not, is there a way to mimic "List from a range" in "Custom formula is?"