开发者

How to set cell-color according to cell-value on ooo-calc?

I can change the style of a cell using conditional formatting. But there I would be limited to a maximum of 3 cases it can handle.

What I want to do is to ge开发者_高级运维t the value of a cell, convert it in a certain way and set the result as the cells background-color.

The simplest example would be cells with values between 0 and 10, resulting in gray-steps between white and black.

Is this possible? Are there ways to set the background-color of a cell automatically?

Thx!


This has been implemented in libreoffice 3.6 (see the release notes)


Format one cell how you want (not one you want to conditionally format).

Press F11 to get the Styles dialogue box

Use the button one from the top right, which is "New Style From Selection"

Type the name you want, e.g. BlackBack

Then do the conditional formatting of the relevant cells, choosing BlackBack


Source: http://www.oooforum.org/forum/viewtopic.phtml?t=61294

Note that you can find "Conditional Formatting" under the Format menu in OOo Calc.


As Joey said: "As far as I can see conditional formatting in OOo cannot do that. Excel has no problems there, though." It's simply not possible... :-/

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜