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)
83 questions
1 vote
1 answer
81 views
Editing the second line in all cells
I am creating a sheet in which the first column has two lines of text in every row. How can I bold the second line only in all cells without doing it manually as I already created the sheet.
- 11
0 votes
0 answers
183 views
Can I use conditional formatting in google sheets to force cells to merge given a specific value [duplicate]
I am working on formatting a cash log for work (work in a restaurant and right now we record this by hand) the problem because each days entry isn’t uniform as the number of people working changes so ...
- 1
-1 votes
1 answer
601 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 ...
- 1
2 votes
2 answers
337 views
How to format ten thousands (만/万)
I know you can format thousands and millions by using a comma in the custom number format. However, I would like to format by ten thousand (man/wan in Asian counting system). For example 10,000,000 =&...
- 127
1 vote
1 answer
25k 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 ...
- 11
2 votes
2 answers
266 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....
- 63
-1 votes
2 answers
35 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 ...
2 votes
1 answer
630 views
Using INDIRECT and a cell reference to compare values on sheets
Simple story - driving me cray cray. I have a single Google Workbook with sheets within with separate names (Sheet1, Sheet2, etc). I have a separate sheet called Compare that I want to make formulas ...
- 23
0 votes
0 answers
344 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 ...
- 1
0 votes
0 answers
238 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 ...
0 votes
0 answers
154 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 ...
- 1
1 vote
2 answers
184 views
Custom format that works for both 8 and 9 digits phone numbers
I want to format a cell to properly display phone numbers, but the number of accepted digits can be either 8 or 9. I am currently using the following format:"387" ## ### ### This works ...
- 11
0 votes
1 answer
686 views
Trying to change Gantt chart in Google Sheets to highlight a cell based on date range and progress percentage
I have been working on a dynamic Gantt chart template in Google Sheets for awhile now. Here's how it currently looks: As you can see, the task bar currently highlights gray dependent on the start and ...
- 21
0 votes
1 answer
1k views
I want date with yyyy/mm/dd format on Google Sheets
I want to convert mm/dd/yyyy to yyyy/mm/dd with function on Google Sheets. I applied TEXT function like the picture but it's not working. How can I convert this?
- 1
0 votes
1 answer
61 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 ...
