| View previous topic :: View next topic |
| Author |
Message |
seanspotatobusiness
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
 |
|
| Back to top |
|
 |
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..  |
|
| Back to top |
|
|
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 |
|
|
| Back to top |
|
|
seanspotatobusiness
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
|
|
| Back to top |
|
|
|
