Thank you so much for this! Note to future self: If you add this: =ISBLANK(A1) as a condition formula for a datarange you can highlight all empty cells. Replace "A1" with first cell in range.
Very interesting! Thank you! Still useful in 2023, 7 years after this video was posted! Merry Christmas and Happy New Year! (this was written in december 22th, 2022).
Hi, Can you help me with LibreOffice Calc - I have multiple links on different rows and I want to open them all on browser (multiple tabs). Similar to using the Hyperlink function in Excel. I don't know how to do it in LibreOffice Calc
I am going crazy trying to do something I've done before, but I forget how. See how your column headers and your 'drag and drop' highlight is blue? How can I change that to a different color? Hope you can help. (Running Linux Mint 17 Qiana Cinnamon 64-bit)
I have a bunch of cells that are either 0 (zero) or 1. However, if I try conditional formatting to change the background color, LibreOffice sees all empty cells as being equal to zero, so they too all get the same color as the cells where I actually typed a zero. How can I keep the empty cells from changing color? edit: I fixed it by making one more condition (in addition to the two I already have for cell value equal to 1 and 0), cell value equal to "" and apply style default and then move that condition to the top. Maybe there's a better way, but this is how I did it for now.
Hello. Nice video, however I have a little different situation. When the value of one cell is say "x," I want to have the option to change either the color background of a different cell(s) in another column, or change the text in different cel(s) in a different column. Is that possible? Also, if you created an different accent in the condition format say you called it "red background" but you want to remove it from the list and just say background color, is that possible. A prompt response would be greatly appreciated. Thanks!
This video has changed my life for the better.
Thank you so much for this!
Note to future self:
If you add this:
=ISBLANK(A1)
as a condition formula for a datarange you can highlight all empty cells. Replace "A1" with first cell in range.
Very interesting! Thank you! Still useful in 2023, 7 years after this video was posted! Merry Christmas and Happy New Year! (this was written in december 22th, 2022).
Thank you Al Gore!
instant subs, so good content dude !
How would you sum all of the values corresponding to the "Allen" product???
Thank you very much, I want to ask you how to filter the column according to the color of background of cells?
viva mexico! nice choice of colors
Is there any such thing as a tutorial that covers the nuances of the formula condition? I didn't see this one discuss it at all.
THANK YOU SO MUCH!!!
Your very welcome, I'm glad it was helpful.
Hi, Can you help me with LibreOffice Calc - I have multiple links on different rows and I want to open them all on browser (multiple tabs). Similar to using the Hyperlink function in Excel. I don't know how to do it in LibreOffice Calc
I am going crazy trying to do something I've done before, but I forget how. See how your column headers and your 'drag and drop' highlight is blue? How can I change that to a different color? Hope you can help. (Running Linux Mint 17 Qiana Cinnamon 64-bit)
WOW YOU'RE LOUD! great vid
That's what the volume slide is for. :-p
Thanks a lot :)
thanks
I have a bunch of cells that are either 0 (zero) or 1. However, if I try conditional formatting to change the background color, LibreOffice sees all empty cells as being equal to zero, so they too all get the same color as the cells where I actually typed a zero. How can I keep the empty cells from changing color?
edit: I fixed it by making one more condition (in addition to the two I already have for cell value equal to 1 and 0), cell value equal to "" and apply style default and then move that condition to the top. Maybe there's a better way, but this is how I did it for now.
Hello. Nice video, however I have a little different situation. When the value of one cell is say "x," I want to have the option to change either the color background of a different cell(s) in another column, or change the text in different cel(s) in a different column. Is that possible? Also, if you created an different accent in the condition format say you called it "red background" but you want to remove it from the list and just say background color, is that possible. A prompt response would be greatly appreciated. Thanks!
Ok thank
Nothing shows up after pressing alt oos
why does libreoffice calc look so crappy 5 years later? all your toolbar icons look well colored and actually useful