LibreOffice Calc - Conditional Formatting

Conditional formatting formats cells according to certain conditions. Color Scale, Data Bar and Icon Sets are demonstrated.
Spreadsheet file used in video available at panopia.com/libreoffice/

[@SuedeKnight]

This video has changed my life for the better.

[@Nicolajmedcogj]

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.

[@JoaoSantos-jb7ul]

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).

[@spikebor]

instant subs, so good content dude !

[@theophrastusvonhoenheim4022]

Thank you Al Gore!

[@skeeterburke]

viva mexico! nice choice of colors

[@NickelCityPixels]

How would you sum all of the values corresponding to the "Allen" product???

[@Al3etreby]

Thank you very much, I want to ask you how to filter the column according to the color of background of cells?

[@MrDavePed]

Thanks a lot :)

[@PurpleGummyBear]

THANK YOU SO MUCH!!!

[@panopiaweb]

Your very welcome, I'm glad it was helpful.

[@my2cents2u]

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)

[@rmus8039]

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!

[@Bonez0r]

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.

[@RoyNBarlow]

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.

[@siddharthupponi8410]

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

[@skeeterburke]

WOW YOU'RE LOUD! great vid

[@my2cents2u]

That's what the volume slide is for. :-p

[@sompod8660]

thanks

[@jotcrafts07]

Ok thank

[@sdfasfaskjgjgugjh6586]

why does libreoffice calc look so crappy 5 years later? all your toolbar icons look well colored and actually useful

[@pawarrakesh5912]

Nothing shows up after pressing alt oos