All Questions
9 questions
-2
votes
1
answer
131
views
Is there a more efficient formula to apply conditional formatting using the ROW function?
I am using a custom formula with conditional formatting on my MAIN tab of my Google Sheet which turns cells in Rows 2:22 RED when an entry is either a '4', an '✘', or outside the upper and lower ...
- 213
1
vote
0
answers
84
views
Conditional Formatting script issue
I'm using an onEdit script whitch moves the entire row with chexbox to an other sheet and reverse.
When I try to apply Conditional Formatting rules with my custom formula whitch looks like this : ='...
- 11
0
votes
1
answer
77
views
Is there a way to tweak this formula to make this work, even if the name doesn't 100% match? If so, how?
I'm trying to use a script to automatically set up conditional formatting to highlight a specific set of names in a Google Sheet. The data comes from a Google Form where people enter their own name. ...
- 71
0
votes
1
answer
148
views
Apps script conditional formatting for value not in array
I have a column containing US state abbreviations. I'd like to have an array of all 50 states:
const states = ['DE','AK','TX','CA' .........]
that the value of each cell in the column is compared ...
- 36.6k
1
vote
1
answer
83
views
Google sheets script is only pulling formatting from the last column and applying it to all appended rows
My script is meant to pull the conditional formatting from each cell and transfer it to the new appended cells. For some reason it is only pulling the data from the last column and applying it to all ...
- 13
0
votes
1
answer
344
views
Google Sheets: Calculate the number of coloured cells IF the check box is marked
I am trying to calculate the number of coloured cells in a column where the check box is also marked.
For example, in column F, there are 2 green cells in rows with marked check boxes. I have failed ...
0
votes
2
answers
273
views
Copy and paste, apply conditional formatting to multiple different ranges and different criteria
I am trying to apply conditional formatting to more than one range. The formatting is always the same but the cell that contains the condition is not.
For example:
`=OR($B$11="金",$B$11="...
- 181
-1
votes
1
answer
186
views
Conditionally format cell color based one 2 values
I have a spreadsheet, the screenshot, I want to color cell E (green), if the text contains "keto" AND "250g". Both of these values not just one. At the moment I don't know how to ...
- 143
3
votes
2
answers
704
views
How to change the color of a cell based on the value of other cells in google sheets
I am aware of conditional formatting in google sheets, but I have a kind of specific use case.
I want the cell n in column A (and all the way down) to be green if ALL the cells in columns N, O or P ...
- 517