Questions tagged [google-sheets-cell-format]

Use for questions about Google Sheets cell format like formatting numbers, dates or using the equal, plus, minus symbols as part of texts (strings)

18 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1 vote
1 answer
4k views

Split / subdivide Google Sheets cell into multiple columns and / or rows

In Google Docs, you can insert a table, right-click a cell, select "Split cell", specify into how many columns (and / or rows) you want to subdivide the cell, and click "Split" to ...
some one's user avatar
1 vote
2 answers
102 views

Alternate colors with masked rows

In Google Sheets, it seems that masking an odd number of rows in a range somehow defeats the alternate color formatting (adjacent rows will occur with identical colors). Is there a workaround using, e....
jmichel's user avatar
  • 41
1 vote
0 answers
26 views

How can I add a thick borderline after a certain text in Google Sheets?

I'm trying to modify my Working Hours Spreadsheet; What I want to do is add a thick borderline after each Sunday, so I can better identify each individual Week of the Month. Here's the Masterfile ...
Adrian Mignogna's user avatar
1 vote
0 answers
2k views

Google Sheets text wrap no longer expands cell

All of a sudden I seem to be having trouble in my Google Sheets auto extending height of cell with text wrap, for certain cells. Mac OS: 10.13.6 (17G65) Chrome: Version 73.0.3683.103 (Official Build)...
user3871's user avatar
  • 263
1 vote
1 answer
6k views

Line spacing in Google Sheets

Is there a way to increase the line spacing in Google Sheets, not the cell padding? I'm referring to the space between the lines in a paragraph that's inside a cell. If not, is there an addon that can ...
Aryadne's user avatar
  • 11
0 votes
0 answers
217 views

Importrange changes the format only for a couple cells

I am using importrange and for some cells google sheets changes the format of only a couple cells. I have attached a screenshot. The original worksheet has the correct dates M/DD/YYYY. So I am ...
Nicky's user avatar
  • 1
0 votes
0 answers
83 views

SI units in Google Sheets

In Google Sheets, I work with data spanning a few orders of magnitude, like mm (millimeter), µm (micrometer), and nm (nanometer). I wrote this formula for a custom number format using conditional ...
evanesco713's user avatar
0 votes
0 answers
66 views

How to recolor all cells based on the original color of the cell in Google Sheets?

I'm looking to recolor cells in a Sheets document I have, simply based on the original color that the cell already has. This is regardless of the contents of the cell and doesn't follow a traditional ...
Moop's user avatar
  • 1
0 votes
1 answer
28 views

How to highlight duplicate values when clicking on a specific cell

I'm new to spreadsheets, but trying to put a functional one together for my team. I have a list of member names, and several lists of tasks they are assigned on different days of the week. The goal is ...
Layson Williams's user avatar
0 votes
0 answers
960 views

How to increase precision up to 18 decimals after decimal point in Google Sheets?

I want to have a number like this in my cell, 18 decimals after decimal point: 10.643958132611619777 But Google Sheets rounds it down to 13 decimals 10.6439581326116 How can I increase precision ...
Green's user avatar
  • 351
0 votes
1 answer
47 views

IF/AND functions from multiple cells

Would anyone know how to fix this problem? I want cell A676 to categorize based on info from 2 cells C676 and D676. Basically IF the word "Paypal" is in cell D, AND there is a specific ...
Lloyd's user avatar
  • 1
0 votes
1 answer
297 views

Google sheet - highlihghting cell if in the same row other cell not empty

I'm trying to make a worksheet where I log shift hours. I made columns with dates and to each date a row of hours I want the date text to be green if in the same row a cell is not empty.. The code I ...
Amir Kh's user avatar
-1 votes
1 answer
136 views

How can I get the same format of cells in my script?

I've made a script, but I need the numbers off 3 rows to be on percentage and I also want to use only 2 decimals and format the date (one of my table colums) as "yyyy-MM-dd". this is my ...
Leo's user avatar
  • 1
-1 votes
2 answers
16 views

Have a cell always populate a certain word but also hide the same column

I would like to hide column C called Type because the input field should always be the same. I know how to hide column C, but I also need column C to always fill with the word Retail so that it ...
Jimmy Wall's user avatar
-1 votes
1 answer
17 views

How could I copy information from multiple cells that share a common feature into one cell?

I have a list of codes that are each assigned to a specific bigger case code and I would like to put a list all of the smaller codes that share one bigger case code in one cell. for example D2-D6 are ...
distressed233's user avatar
-1 votes
1 answer
362 views

Create a RAG system based on dates, upcoming and expired within Google Sheets

I want to create a RAG system in google sheets based on dates in a cell. Column A will show a date when someone is trained on a topic and column B shows the due refresher date (3 years later). I want ...
Simon's user avatar
  • 1
-1 votes
1 answer
18 views

How can I search an argument in GSheets to return TRUE if the argument references another cell?

Hello! In some cells in the True Price Column, I applied a discount by referencing the cell Conv!C2. For example, the argument in D13 is =MROUND((D8 * 2) * Conv!C2, 5) where (D8 * 2) is me calculating ...
Plushie Puppy's user avatar
-1 votes
1 answer
1k views

How to format a negative number red within a mixed formula result

We use the following formula: ="Stu/W: " & TEXT((A$2/B2),"[Red]#,###,##0.00") &"€" and wish to have the resulting negative currency numbers colored red and positive blue. Unfortunately ...
marikamitsos's user avatar
  • 12.6k