How do I conditional format entire row based on a single cell using google Sheets python API script?
1
I am able to use the Google Sheets API (python) to conditionally format (change the cell color of) a single cell based on a user input value but not the entire row. Is there any way to do this? Here's the code I'm using that works for a single cell (just the cell that's being changed). "addConditionalFormatRule": { "rule": { "ranges": [ { "sheetId": tabidnumber, "startRowIndex": 1, "endRowIndex": row_count } ], "booleanRule": { "condition": { "type": "TEXT_EQ", "values": [ { "userEnteredValue&q