gs-conditional-formatting Questions
5
Solved
While trying to remove duplicate phone numbers from a relatively large list I recently combined, Google Sheets presented me with this error message:
There was a problem.
Your selection contains...
Mumps asked 6/7, 2019 at 14:59
7
Solved
I need to write a conditional format rule with a custom formula, that should trigger when the certain cell's (the cell in the 3rd row of the column of the current cell) value is "TODAY()", and the ...
Keever asked 9/2, 2016 at 19:1
9
Is there a way to remove the conditional formatting from cells, while keeping the applied format intact?
Publias asked 11/2, 2016 at 15:45
4
Solved
I want to highlight the cell in column A if it is repeated anywhere in column B. For example:
A | B
pack_1 | unrelated
pack_2 | unrelated
pack_3 | pack_1
pack_4 | pack_1
pack_5 | pack_3
pack_6 | p...
Aplanatic asked 14/3, 2015 at 17:16
5
I want to format the whole row depending on if a particular cell in that is empty or not. I want conditional formatting to go through all rows and say add a background color if column C in that row...
Normalie asked 4/3, 2014 at 11:2
6
Solved
I need a way to remove all conditional formatting by running a script (my client will be using this and he doesn't want to have to repeat the process of removing conditional formatting for each wor...
Slouch asked 25/7, 2017 at 1:31
1
Solved
I'm looking for some conditional formatting solution where a new cell background color is set to a unique cell text. The image below shows this.
The tricky part is that I won't know any of the v...
Hindgut asked 1/4, 2020 at 22:3
3
Solved
I'm looking to create some conditional formatting based upon a set of three percentage categories (please see the following sheet), where a color is applied to multiple cells, but not all in a row:...
Tucci asked 21/3, 2016 at 16:33
4
Solved
Google Sheets has a great interactive way to declaratively define conditional formatting. Is there a way to program the same declarative model using App Script?
I have a script that generates many...
Milburn asked 26/2, 2016 at 17:36
4
Solved
I am trying to figure out how to use conditional formatting on a google spreadsheet similar to what you can do in excel via a formula.
I want cell A2 to change to Green if cell O2 has a value of "...
Worker asked 18/5, 2012 at 13:47
4
Google Spreadsheets can copy cell format to destination cell, but it seems "Conditional formatting" information didn't be copied.
Can we just copy the "Conditional formatting" from one document to...
Alnico asked 19/9, 2014 at 14:10
1
Solved
Given the sheet:
A| B | C = SUM($D2:$Z2) | D | E | F | ...
How would I, for a range of rows (for example: 4:50), color columns Cx:Zx (for row x) if Bx > Cx, without making a conditional rule ...
Mashie asked 21/12, 2018 at 18:16
2
Solved
While applying conditional formatting in Google spreadsheet, I was wondering if it's possible to use a custom function that I created via script editor in the field 'custom formula is:'. Here is wh...
google-apps-scriptgoogle-sheetsgs-conditional-formattinggoogle-sheets-custom-functiongoogle-sheets-conditionalformatting
Undo asked 15/2, 2016 at 20:16
2
Solved
At our marketing company/agency, we're using a master tracker in Google Sheets to keep track of all paid advertising campaigns that we are handling for our clients. The document is getting longer a...
Winstead asked 21/8, 2016 at 2:56
1
I struggle to apply my desired formatting to a spread sheet. A small example can be found here.
I have many rows of numbers, and I want to conditionally format each row by the same format, but e...
Ceceliacecil asked 26/7, 2017 at 7:37
2
I need a formula/script for a Google spreadsheet that will do this:
If the current cell value is higher than the value in the cell above the make the current cell background red (if less than or e...
Default asked 28/6, 2013 at 2:50
3
Solved
I am trying to get a Google spreadsheet to automatically highlight all rows in a spreadsheet where the value in a particular column is above 0. I have looked for a few solutions but haven't got it ...
Mauve asked 28/3, 2013 at 18:4
4
Solved
I need a color scale on a row or column in Google Spreadsheet, like the one provided by Microsoft Office Excel conditional formatting with color scale:
I couldn't find a Google Script Gallery Sc...
Embattled asked 28/10, 2013 at 14:32
5
Solved
I have a Google spreadsheet where I keep a list of bugs and whenever I fix a bug I change the status from "Not Started" to "Complete". I want to write a script for the Google Docs spreadsheet such ...
Rashida asked 13/9, 2010 at 19:26
3
Solved
I have a google sheet where I want the range A:D to format a certain color if the contents of A2 contain the word Order (case insensitive). Right now I have the following:
Conditional Format appl...
Strafe asked 22/5, 2015 at 16:33
1
Solved
Very simply, I am attempting to highlight a cell if that cell matches (exactly) with a different cell from a different column (in a different sheet, specifically).
For example, I have an 'Active' ...
Ellett asked 6/7, 2015 at 5:9
2
Solved
It's my first time working with Google scripts. I want to change the background color of a row and text when the row contains certain values. I've had some success using this piece of code:
functi...
Nippon asked 29/1, 2015 at 14:16
1
Solved
I have a sheet where each row starts with the dates of each Sunday throughout the year. I want to change the formatting for all rows that are "past". I also want only the NEXT Sunday (based on the ...
Mislead asked 14/1, 2015 at 23:31
1
Solved
I have a google spreadsheet which has columns for each day (with the date in the top cell) and in each cell a string indicating status.
I need to apply conditional formatting to cells based on the...
Wicks asked 12/1, 2015 at 15:39
1
Solved
I have a Google sheet of this form:
A B C D E
1 A1 B1 C1 D1 E1
2 A2 B2 C2 D2 E2
3 A3 B3 C3 D3 E3
4 A4 B4 C4 D4...
Noahnoak asked 3/7, 2014 at 22:42
1 Next >
© 2022 - 2024 — McMap. All rights reserved.