I have this situation:
4.ods (26.3 KB)
How can i make it so that the cells on the A column take the color from the B column?
Also, How to make it so that values equal to or greater than 1000 have all the same color?
LibreOffice 26.2.2.2 620(Build:2)
Thank you.
color_scale cannot be applied to other cells, but perhaps an old-fashioned CF scheme might do the trick for you
That doesn’t work with Color_Scale either.
But you’re welcome to create 10 or even 20 different cell styles and use the classic version (but you’ll have to do that yourself, my friend).
ask134578_classic_cf.ods (26.3 KB)
Found the answer for the second question: just put the first and last values in the conditional formatting, and not leave the generic min and max.