Timeline for Automatically add borders around nonempty cells
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 13, 2023 at 0:29 | review | Suggested edits | |||
| Feb 7, 2023 at 11:17 | |||||
| Jan 24, 2022 at 11:48 | comment | added | robotik | this method works - almost. beware the two problems below: 1. border: None doesn't work as a conditional, so if there's a border that you want to disappear on condition, you have to set up something else. white border is replaced with blue in Google Sheets, 15% gray works on screen, but not in print, so I chose 5% gray (a bit too light on screen, but barely visible on print). 2. when you try to change existing border color, it applies to top, bottom and inner borders, but not so much on left and right borders (if they are left of one affected cell and right of the other, then it works) | |
| S Aug 1, 2021 at 9:38 | history | suggested | tkp | CC BY-SA 4.0 |
Added link to an example GSheet.
|
| Jul 17, 2021 at 21:05 | review | Suggested edits | |||
| S Aug 1, 2021 at 9:38 | |||||
| Mar 3, 2021 at 6:09 | comment | added | Hassan Almaateeq | Thanks. I tried to adapt that code for my sheet. Basically I want all the rows to be bordered whenever a single cell of that row was edited or nonempty. <docs.google.com/spreadsheets/d/…>. Could you please figure it out | |
| May 4, 2017 at 10:45 | history | edited | serenesat | CC BY-SA 3.0 |
added 1 character in body
|
| May 4, 2017 at 8:46 | review | Late answers | |||
| May 4, 2017 at 10:45 | |||||
| May 4, 2017 at 8:29 | review | First posts | |||
| May 4, 2017 at 12:08 | |||||
| May 4, 2017 at 8:26 | history | answered | user154134 | CC BY-SA 3.0 |