Ask Your Question

Can I have continuous coloring of cells by conditional formatting? [closed]

asked 2012-02-21 11:49:05 +0200

Masoud gravatar image

I have a long column of numbers, ranged from 0 to 1 (like 0.133, 0.45, 0.5, 0.673 etc.). I would like to be able to color them automatically in a continuous manner. I mean, I want to color 0 as white, and color 1 as blue, and color any other cell with a color proportional to its value. In terms of RGB, I want to color all my cells like 'RGB(0,0,255*VALUE)'

If it was gnuplot, I could do it like the examples in this page.

Is it possible in LibreOffice?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-15 05:15:23.520577


Beginning with Libreoffice 3.6 you will be able to use color scales for this.

moggi gravatar imagemoggi ( 2012-05-13 02:28:12 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2012-02-24 09:57:44 +0200

drone27of1 gravatar image

You could make a macro to do this. See here

Other options are out there such as creating new styles and using conditional formatting but you will not get the range in colors.

edit flag offensive delete link more

Question Tools


Asked: 2012-02-21 11:49:05 +0200

Seen: 774 times

Last updated: Feb 24 '12