Timeline for How to color rows based on cell value in OpenOffice and LibreOffice
Current License: CC BY-SA 4.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 14, 2023 at 15:31 | comment | added | tohuwawohu | @nulll: Sorry, you're right, my last example applies to the column, not the row. I've added another example for a conditional formatting applying to a row based on the value in a certain column. | |
| Dec 14, 2023 at 15:30 | history | edited | tohuwawohu | CC BY-SA 4.0 |
another example
|
| Dec 14, 2023 at 9:50 | comment | added | nulll | To me version for LibreOffice 7 colorizes only the column, not the whole row | |
| S Mar 2, 2023 at 8:39 | history | suggested | T.J. Crowder | CC BY-SA 4.0 |
Explain about the row number in the formula, since it's not obvious (or wasn't to me, anyway)
|
| Mar 2, 2023 at 8:14 | review | Suggested edits | |||
| S Mar 2, 2023 at 8:39 | |||||
| May 26, 2021 at 13:33 | vote | accept | Cerin | ||
| May 26, 2021 at 9:55 | comment | added | tohuwawohu | @Cerin: Since you can set the affected cell range using the usual cell range syntax, you don't need to select cells, columns or other ranges manually. You can still do so if you want (using the button right of the "Range" input field), but you don't have to. | |
| May 26, 2021 at 9:12 | history | edited | tohuwawohu | CC BY-SA 4.0 |
update for LO 7.1.3.
|
| May 26, 2021 at 9:06 | history | edited | tohuwawohu | CC BY-SA 4.0 |
update for LO 7.1.3.
|
| S May 25, 2017 at 7:56 | history | suggested | egor83 | CC BY-SA 3.0 |
updated menu names
|
| May 25, 2017 at 5:19 | review | Suggested edits | |||
| S May 25, 2017 at 7:56 | |||||
| Mar 20, 2017 at 10:04 | history | edited | CommunityBot |
replaced http://superuser.com/ with https://superuser.com/
|
|
| Aug 10, 2013 at 10:44 | history | answered | tohuwawohu | CC BY-SA 3.0 |