findCells
Search for cells matching specified criteria within a sheet or range. Returns up to 200 matches. Use matchMode to control whether all criteria must match (AND, default) or any (OR). Range iteration is limited to 10,000 cells — use sheet scope for larger searches.
| Parameter | Type | Description | |
|---|---|---|---|
sheet | string | optional | Restrict search to a single sheet by name. |
range | string | optional | Restrict search to an A1-style range, e.g. ‘Sheet1!B2:D10’ or ‘B2:D10’. An unqualified range resolves against ‘sheet’ if given, otherwise the first sheet. Defined names are not accepted. Ranges larger than 10,000 cells are rejected. |
matchMode | "AND" | "OR" | optional | ”AND” = all criteria must match (narrows results). “OR” = any criterion matches (broader sweep). Defaults to “AND”. |
hasFormula | boolean | optional | Match cells that have (true) or don’t have (false) a formula. |
fillColor | string | optional | Match cells whose fill color matches this search term. Accepts hex values (“FFFF00”, “#FF0000”), partial hex (“FF”), color family words (“yellow”, “blue”, “gray”) which match by hue, specific color names (“light blue”, “dark green”) which match the nearest named color, and theme scheme names (“accent1”). Theme, indexed, and auto colors are resolved through the workbook theme. Case-insensitive. |
fontColor | string | optional | Match cells whose font color matches this search term. Accepts hex values (“0000FF”, “#FF0000”), partial hex, color family words (“blue”, “red”, “gray”) which match by hue, specific color names (“steel blue”) which match the nearest named color, and theme scheme names (“accent1”). Theme, indexed, and auto colors are resolved through the workbook theme. Case-insensitive. Useful for auditing color-coding conventions (e.g. blue font = hardcoded input). |
formulaContains | string | optional | Match cells whose formula text contains this substring (case-insensitive). |
valueContains | string | optional | Match cells whose value (converted to text) contains this substring (case-insensitive). |
valueWithin | number[] | optional | Match cells whose numeric value falls within this inclusive range [min, max]. |