Hello, I am trying to create a spreadsheet that alerts me (ie via any type of text, conditional formatting with color, etc..) when say C1:C18, D1:D18, E1:E18, etc.... all contain the same value from another spreadsheet. For example, if a range of those values all contain a "1" (ie. 18 ones in that column consecutively, update another spreadsheet with a red color or notation to please review.
So, the ranges on a given tab are from C1:C18 thru T1:T18, and would need to check across tabs in that spreadsheet and 2 other spreadsheets with multiple tabs that are setup identically. This would be keeping in mind that the import formula from another sheet only allows for a max of 50 imports in a given spreadsheet. Any input would be appreciated. Thank you -Dan -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
