[Solved] Question about adding to toolbar
-
- Posts: 6
- Joined: Tue Oct 25, 2016 5:22 pm
[Solved] Question about adding to toolbar
I have a list that I go down and check each one to be valid or not. I use 4 colors to differentiate the differences on this list. Is there a way I can add just those 4 background colors to my tool bar or maybe add a macro to make it faster and easier?
Last edited by Hagar Delest on Tue Oct 25, 2016 10:08 pm, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
openoffice 3.1
Re: Question about adding to toolbar
Possibly you could use Conditional formatting to change the background colours? For more than three colours use extension
http://extensions.openoffice.org/en/pro ... formatting
http://extensions.openoffice.org/en/pro ... formatting
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
-
- Posts: 6
- Joined: Tue Oct 25, 2016 5:22 pm
Re: Question about adding to toolbar
Could you explain please? Not familiar with formatting or extensions.
openoffice 3.1
Re: Question about adding to toolbar
In OpenOffice /Help /OpenOffice Help: Index tab, enter "Conditional formatting" and separately "extensions" (no quotes on either search).
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
-
- Posts: 6
- Joined: Tue Oct 25, 2016 5:22 pm
Re: Question about adding to toolbar
This might help you
[Solved] Changing cells to red or green in Calc
[Solved] Changing cells to red or green in Calc
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
-
- Posts: 6
- Joined: Tue Oct 25, 2016 5:22 pm
Re: Question about adding to toolbar
If it would, I don't understand it =/ I'm complete noob at this stuff. I just want to add a button or four to the toolbar that I click and it makes the cell(s) a specific color. Lets say I find row 13 to be something I wanna highlight in green. So I click the 13 and instead of going to the paint can and picking a color I would like to be able to just click the "Green" button as a short cut. Same with "Red", "Yellow" and "Grey" If that makes any sense.
openoffice 3.1
- Hagar Delest
- Moderator
- Posts: 32667
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Question about adding to toolbar
You can create 4 macros to apply the background colors.
Then you can add buttons in the toolbar to launch those macros.
You should find such code snippet in the macro forum.
Or use styles and apply them with the Sidebar and the Styles list.
Please add [Solved] at the beginning of the title in your first post (top of the topic) with the edit button if your issue has been fixed.
Then you can add buttons in the toolbar to launch those macros.
You should find such code snippet in the macro forum.
Or use styles and apply them with the Sidebar and the Styles list.
Please add [Solved] at the beginning of the title in your first post (top of the topic) with the edit button if your issue has been fixed.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
-
- Posts: 6
- Joined: Tue Oct 25, 2016 5:22 pm
Re: Question about adding to toolbar
I just figured out how to do it and came here to mark it solved when I read you comment but thanks so much for your help. I was starting to lose hope lol anything I can do to for you? like upvote or give a rating?
openoffice 3.1
- Hagar Delest
- Moderator
- Posts: 32667
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: [Solved] Question about adding to toolbar
We have no rating or such reward process.
However, I can give you my bank account references, 6-figure transfers (or above) are welcome.
However, I can give you my bank account references, 6-figure transfers (or above) are welcome.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
-
- Posts: 6
- Joined: Tue Oct 25, 2016 5:22 pm