Stack Overflow
Stack Overflow

Questions tagged [gs-conditional-formatting]

Controlling the appearance of cell ranges in a Google Sheets spreadsheet (e.g., font, text style, or fill), conditional upon the content of cells.

Conditional formatting of cells in a Google Sheets spreadsheet.

https://support.google.com/docs/answer/78413?co=GENIE.Platform%3DDesktop&hl=en

547 questions
90
votes
6 answers

How to address the current cell in conditional format custom formula?

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 current cell is empty. I know how to check the other…
Vladimir Mikhaylovskiy
  • 1,955
  • 4
  • 19
  • 28
89
votes
4 answers

How can I copy a conditional formatting from one document to another?

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 another? I know we can recreate it from the…
user2575413
58
votes
5 answers

Script to Change Row Color when a cell changes text

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 that whenever I change the status to "Complete" the…
MadSeb
  • 7,958
  • 21
  • 80
  • 121
37
votes
2 answers

Automatic colouring of a specific value wherever found in a table

I am looking for a way to automatically change the color of the minimum cell in a row in Google Sheets. So, for a table like: 1 | 2 | 3 4 | 2 | 1 2 | 1 | 6 it would color all the cells with 1 in them.
Verhogen
  • 27,221
  • 34
  • 90
  • 109
35
votes
5 answers

Format entire row if a particular cell in the row is not empty

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 is not empty. How do I fix this?
user3378720
  • 359
  • 1
  • 3
  • 3
20
votes
3 answers

How do I get google sheet conditional formatting custom formulas to refer to relative cells?

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 applies to range - A:D Format cells if... - "Custom…
user3499449
  • 263
  • 1
  • 2
  • 7
20
votes
4 answers

Google Spreadsheet conditional formatting script

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 "X" and this will be done on both columns all the way…
PY_
  • 1,189
  • 8
  • 18
  • 29
17
votes
4 answers

Highlight cell if value is present in any cell in another column

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 | pack_3 pack_7 | unrelated pack_8 | pack_2 In the…
azizLIGHT
  • 173
  • 1
  • 1
  • 4
16
votes
4 answers

Color scale with conditional formatting in Google Spreadsheet

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 Script that can do exactly this job. Setting conditional…
Underlines
  • 809
  • 1
  • 8
  • 17
13
votes
4 answers

How To Detect Which Cells Are Merged In Google Sheets

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 a merged cell. To remove duplicates, all cells must…
Ethan
  • 1,905
  • 2
  • 21
  • 50
13
votes
9 answers

Google spreadsheet: Remove conditional formatting, but keep the format

Is there a way to remove the conditional formatting from cells, while keeping the applied format intact?
Sebastian Hofer
  • 163
  • 1
  • 1
  • 7
12
votes
6 answers

How to clear conditional formatting (not all formatting) in Google Apps script

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 worksheet in each of a large number of spreadsheet…
Hannah S.
  • 338
  • 1
  • 4
  • 11
10
votes
2 answers

Conditional formatting in Google Sheets: Can I use custom function in the 'custom formula is:' field?

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 what I did: Went to 'script editor' and typed my fn…
bash2day
  • 143
  • 1
  • 8
9
votes
3 answers

How to duplicate (not extend) conditional formatting rule?

I have a conditional formatting rule (color scale) applied to a row (e.g. A1:Z1). I want the to duplicate this rule for another row, but when I use Paste Special -> Paste Conditional Formatting Only (or Paint Format tool), it simply makes the color…
Asu
  • 1,723
  • 2
  • 21
  • 32
8
votes
2 answers

How to speed up heavy conditional formatting rules

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 and longer, and the variety of conditional formatting…
Henrik Söderlund
  • 413
  • 1
  • 6
  • 15
1
2 3
…
36 37