[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
OOo Enthusiast

Joined: 31 Oct 2005
Posts: 176

 Posted: Fri Apr 04, 2008 1:14 am    Post subject: Conditional format to entire row How do I apply a conditional format to an entire row based on the value of a single cell in that row? I can do it to a single row using a formula based on the important cell in that row, but if I select many rows first, what do I enter for the formula?_________________Win 7; OOo 3.2
Tribio
General User

Joined: 04 Dec 2007
Posts: 28
Location: Belgium

 Posted: Fri Apr 04, 2008 1:24 am    Post subject: I think that if you select multiple rows, and want to make their format depend on the value of ONE cell, the same method applies. If you mean that you want to apply the conditional format for each row, depending on a cell on each of those rows, then you'll have to make a conditional format for each row (or you can 'copy - paste special - format' the first row where the conditional format is already made.. (make sure to work with \$A1 or so instead of \$A\$1) Excuse my English, looks like my brain is already in the mood for the weekend..
huwg
Super User

Joined: 14 Feb 2007
Posts: 890

Posted: Fri Apr 04, 2008 2:25 am    Post subject:

This is one I use across a range:
 Code: Condition 1   Cell value is   MAX(\$C\$2:\$D\$200)   Cell Style   Hi Condition 2   Cell value is   MIN(\$C\$2:\$D\$200)   Cell Style   Lo

This is one I use on a rows:
 Code: Condition 1   Formula is   LEFT(\$B1;1)="?"   Cell Style   Red
OOo Enthusiast

Joined: 31 Oct 2005
Posts: 176

Posted: Fri Apr 04, 2008 7:28 am    Post subject:

 Tribio wrote: If you mean that you want to apply the conditional format for each row, depending on a cell on each of those rows, then you'll have to make a conditional format for each row (or you can 'copy - paste special - format' the first row where the conditional format is already made.. (make sure to work with \$A1 or so instead of \$A\$1)

This is the info I needed. Thank you both for your replies.
_________________
Win 7; OOo 3.2

 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
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