How do I conditional format entire row based on a single cell using google Sheets python API script?
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": "WAITING"
}
]
},
"format": {
"backgroundColor": {
"green": 0.5,
"red": 0.5,
}},
}
},
"index": 1
}
}
Thanks!
google-sheets formatting conditional row google-sheets-api
edited Nov 29 '18 at 2:29
Tanaike
23.6k21325
asked Nov 28 '18 at 14:12
IdanIdan
61
add a comment |
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": "WAITING"
}
]
},
"format": {
"backgroundColor": {
"green": 0.5,
"red": 0.5,
}},
}
},
"index": 1
}
}
Thanks!
google-sheets formatting conditional row google-sheets-api
edited Nov 29 '18 at 2:29
Tanaike
23.6k21325
asked Nov 28 '18 at 14:12
IdanIdan
61
Did my answer show you the result what you want? Would you please tell me about it? That is also useful for me to study. If this works, other people who have the same issue with you can also base your question as a question which can be solved. If you have issues for my answer yet, feel free to tell me. I would like to study to solve your issues.
– Tanaike
Nov 29 '18 at 22:25
Possible duplicate of Update single row formatting for entire sheet
– tehhowch
Dec 2 '18 at 16:12
add a comment |
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": "WAITING"
}
]
},
"format": {
"backgroundColor": {
"green": 0.5,
"red": 0.5,
}},
}
},
"index": 1
}
}
Thanks!
google-sheets formatting conditional row google-sheets-api
edited Nov 29 '18 at 2:29
Tanaike
23.6k21325
asked Nov 28 '18 at 14:12
IdanIdan
61
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": "WAITING"
}
]
},
"format": {
"backgroundColor": {
"green": 0.5,
"red": 0.5,
}},
}
},
"index": 1
}
}
Thanks!
google-sheets formatting conditional row google-sheets-api
google-sheets formatting conditional row google-sheets-api
edited Nov 29 '18 at 2:29
Tanaike
23.6k21325
asked Nov 28 '18 at 14:12
IdanIdan
61
edited Nov 29 '18 at 2:29
Tanaike
23.6k21325
asked Nov 28 '18 at 14:12
IdanIdan
61
edited Nov 29 '18 at 2:29
Tanaike
23.6k21325
edited Nov 29 '18 at 2:29
Tanaike
23.6k21325
edited Nov 29 '18 at 2:29
Tanaike
23.6k21325
23.6k21325
asked Nov 28 '18 at 14:12
IdanIdan
61
asked Nov 28 '18 at 14:12
IdanIdan
61
asked Nov 28 '18 at 14:12
IdanIdan
61
61
Did my answer show you the result what you want? Would you please tell me about it? That is also useful for me to study. If this works, other people who have the same issue with you can also base your question as a question which can be solved. If you have issues for my answer yet, feel free to tell me. I would like to study to solve your issues.
– Tanaike
Nov 29 '18 at 22:25
Possible duplicate of Update single row formatting for entire sheet
– tehhowch
Dec 2 '18 at 16:12
add a comment |
Did my answer show you the result what you want? Would you please tell me about it? That is also useful for me to study. If this works, other people who have the same issue with you can also base your question as a question which can be solved. If you have issues for my answer yet, feel free to tell me. I would like to study to solve your issues.
– Tanaike
Nov 29 '18 at 22:25
Possible duplicate of Update single row formatting for entire sheet
– tehhowch
Dec 2 '18 at 16:12
Did my answer show you the result what you want? Would you please tell me about it? That is also useful for me to study. If this works, other people who have the same issue with you can also base your question as a question which can be solved. If you have issues for my answer yet, feel free to tell me. I would like to study to solve your issues.
– Tanaike
Nov 29 '18 at 22:25
Did my answer show you the result what you want? Would you please tell me about it? That is also useful for me to study. If this works, other people who have the same issue with you can also base your question as a question which can be solved. If you have issues for my answer yet, feel free to tell me. I would like to study to solve your issues.
– Tanaike
Nov 29 '18 at 22:25
Possible duplicate of Update single row formatting for entire sheet
– tehhowch
Dec 2 '18 at 16:12
Possible duplicate of Update single row formatting for entire sheet
– tehhowch
Dec 2 '18 at 16:12
add a comment |
1 Answer
1
active
oldest
votes
For example, when startRowIndex is 1 and endRowIndex is not used, Sheets API uses the range as from row 2 to the end of row of Sheet. So please remove endRowIndex from ranges in your request body and try to run again. By this, this update is reflected to the entire row of the sheet.
Modified request body:
"addConditionalFormatRule": {
"rule": {
"ranges": [
{
"sheetId": tabidnumber,
"startRowIndex": 1
}
],
"booleanRule": {
"condition": {
"type": "TEXT_EQ",
"values": [
{
"userEnteredValue": "WAITING"
}
]
},
"format": {
"backgroundColor": {
"green": 0.5,
"red": 0.5
}
}
}
},
"index": 1
}
Note:
- I had known this from my experience. Although I had looked for the reference documents related to this, I couldn't find it. I'm sorry.
answered Nov 29 '18 at 2:27
TanaikeTanaike
23.6k21325
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53521413%2fhow-do-i-conditional-format-entire-row-based-on-a-single-cell-using-google-sheet%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
For example, when startRowIndex is 1 and endRowIndex is not used, Sheets API uses the range as from row 2 to the end of row of Sheet. So please remove endRowIndex from ranges in your request body and try to run again. By this, this update is reflected to the entire row of the sheet.
Modified request body:
"addConditionalFormatRule": {
"rule": {
"ranges": [
{
"sheetId": tabidnumber,
"startRowIndex": 1
}
],
"booleanRule": {
"condition": {
"type": "TEXT_EQ",
"values": [
{
"userEnteredValue": "WAITING"
}
]
},
"format": {
"backgroundColor": {
"green": 0.5,
"red": 0.5
}
}
}
},
"index": 1
}
Note:
- I had known this from my experience. Although I had looked for the reference documents related to this, I couldn't find it. I'm sorry.
answered Nov 29 '18 at 2:27
TanaikeTanaike
23.6k21325
add a comment |
For example, when startRowIndex is 1 and endRowIndex is not used, Sheets API uses the range as from row 2 to the end of row of Sheet. So please remove endRowIndex from ranges in your request body and try to run again. By this, this update is reflected to the entire row of the sheet.
Modified request body:
"addConditionalFormatRule": {
"rule": {
"ranges": [
{
"sheetId": tabidnumber,
"startRowIndex": 1
}
],
"booleanRule": {
"condition": {
"type": "TEXT_EQ",
"values": [
{
"userEnteredValue": "WAITING"
}
]
},
"format": {
"backgroundColor": {
"green": 0.5,
"red": 0.5
}
}
}
},
"index": 1
}
Note:
- I had known this from my experience. Although I had looked for the reference documents related to this, I couldn't find it. I'm sorry.
answered Nov 29 '18 at 2:27
TanaikeTanaike
23.6k21325
add a comment |
For example, when startRowIndex is 1 and endRowIndex is not used, Sheets API uses the range as from row 2 to the end of row of Sheet. So please remove endRowIndex from ranges in your request body and try to run again. By this, this update is reflected to the entire row of the sheet.
Modified request body:
"addConditionalFormatRule": {
"rule": {
"ranges": [
{
"sheetId": tabidnumber,
"startRowIndex": 1
}
],
"booleanRule": {
"condition": {
"type": "TEXT_EQ",
"values": [
{
"userEnteredValue": "WAITING"
}
]
},
"format": {
"backgroundColor": {
"green": 0.5,
"red": 0.5
}
}
}
},
"index": 1
}
Note:
- I had known this from my experience. Although I had looked for the reference documents related to this, I couldn't find it. I'm sorry.
answered Nov 29 '18 at 2:27
TanaikeTanaike
23.6k21325
For example, when startRowIndex is 1 and endRowIndex is not used, Sheets API uses the range as from row 2 to the end of row of Sheet. So please remove endRowIndex from ranges in your request body and try to run again. By this, this update is reflected to the entire row of the sheet.
Modified request body:
"addConditionalFormatRule": {
"rule": {
"ranges": [
{
"sheetId": tabidnumber,
"startRowIndex": 1
}
],
"booleanRule": {
"condition": {
"type": "TEXT_EQ",
"values": [
{
"userEnteredValue": "WAITING"
}
]
},
"format": {
"backgroundColor": {
"green": 0.5,
"red": 0.5
}
}
}
},
"index": 1
}
Note:
- I had known this from my experience. Although I had looked for the reference documents related to this, I couldn't find it. I'm sorry.
answered Nov 29 '18 at 2:27
TanaikeTanaike
23.6k21325
answered Nov 29 '18 at 2:27
TanaikeTanaike
23.6k21325
answered Nov 29 '18 at 2:27
TanaikeTanaike
23.6k21325
answered Nov 29 '18 at 2:27
TanaikeTanaike
23.6k21325
23.6k21325
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53521413%2fhow-do-i-conditional-format-entire-row-based-on-a-single-cell-using-google-sheet%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Did my answer show you the result what you want? Would you please tell me about it? That is also useful for me to study. If this works, other people who have the same issue with you can also base your question as a question which can be solved. If you have issues for my answer yet, feel free to tell me. I would like to study to solve your issues.
– Tanaike
Nov 29 '18 at 22:25
Possible duplicate of Update single row formatting for entire sheet
– tehhowch
Dec 2 '18 at 16:12