OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

cell background

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
autophil
General User
General User


Joined: 08 Oct 2008
Posts: 22
Location: Cape Town

PostPosted: Sun Nov 16, 2008 11:28 am    Post subject: cell background Reply with quote

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.
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Sun Nov 16, 2008 11:35 am    Post subject: Re: cell background Reply with quote

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.
Back to top
View user's profile Send private message
autophil
General User
General User


Joined: 08 Oct 2008
Posts: 22
Location: Cape Town

PostPosted: Mon Nov 17, 2008 10:12 am    Post subject: Reply with quote

OK. I got that one right. Its a pity we are limited to only 3 options.
phil
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Mon Nov 17, 2008 10:27 am    Post subject: Reply with quote

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 https://forum.openoffice.org
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group