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

Conditional format to entire row

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
seanspotatobusiness
OOo Enthusiast
OOo Enthusiast


Joined: 31 Oct 2005
Posts: 176

PostPosted: Fri Apr 04, 2008 1:14 am    Post subject: Conditional format to entire row Reply with quote

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

Back to top
View user's profile Send private message
Tribio
General User
General User


Joined: 04 Dec 2007
Posts: 28
Location: Belgium

PostPosted: Fri Apr 04, 2008 1:24 am    Post subject: Reply with quote

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.. Smile
Back to top
View user's profile Send private message Visit poster's website
huwg
Super User
Super User


Joined: 14 Feb 2007
Posts: 890

PostPosted: Fri Apr 04, 2008 2:25 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
seanspotatobusiness
OOo Enthusiast
OOo Enthusiast


Joined: 31 Oct 2005
Posts: 176

PostPosted: Fri Apr 04, 2008 7:28 am    Post subject: Reply with quote

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

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