cell background

autophil · Posted: Sun Nov 16, 2008 11:28 am Post subject: cell background

Gmorning.
Is there a way to set up a spreadsheet so that the background of each cell is dependant on the text content? For instance if I type in "A" in a cell the background is red. Or if the text is "Yes" then the background is blue?
Thanks!!
Phil.

David · Posted: Sun Nov 16, 2008 11:35 am Post subject: Re: cell background

Yes. Conditional formatting. However, the number of entries is unlimited while the number of colours is not. The number of conditions is even more limited [three for some reason].

David.

autophil · Posted: Mon Nov 17, 2008 10:12 am Post subject:

OK. I got that one right. Its a pity we are limited to only 3 options.
phil

Villeroy · Posted: Mon Nov 17, 2008 10:27 am Post subject:

You could use function style, but that will not format constant values, only formulas. You could style a column next to the text entries.
http://user.services.openoffice.org/en/forum/viewtopic.php?t=3791&p=17019#p17019

I wrote a macro that elegantly overcomes the limitation of 3 conditional formattings. The limitation is just in the GUI, the file format can store many more. Once the macro has set the desired c.f you don't need it anymore for those particular cells. It will work independent from the macro.
http://user.services.openoffice.org/en/forum/viewtopic.php?t=6039&p=28159#p28159
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org