Hi everyone
I have a problem with conditional formatting in Calc.
I want to apply a style to a cell if the value in another cell meets a certain
criteria. For example, I want the style in cell A1 to change if A2 is greater
than 100.
As far as I can see, it is only possible to apply the condit
Is it not possible in Calc to conditionally change the background colour
of a cell? I see that it is possible to change the text style, but I
cannot find where/how to change the colour.
Thanks,
Keith
-
To unsubscribe, e-mail:
OMG!!! hours and hours of work done in like an hour :D
I have been cleaning up my sheets to make them easier to read now that
these formulas from today are working.
Last thing I want to do is format the background of the cell to one of
two colors based on a series of numbers.
I have that wo
Hi all
As far as I can see it's only possible to have 3 levels of conditional
formatting. Does anyone know of a trick or workaround to get more
conditions to apply. Ideally i would like six and any suggestions would
be gratefully appreciated.
-
I have major doubt in using calc ... plz help me
issue is :
First i create a data for the 50 lines i have put ( conditional formatting )
for all the 50 lines ]
After that i insert a new row after 25 th row .. conditonal format has gone
from 26th to 50 ...
give me a solution for t
Hi!
When I press the help button in "conditional formatting" dialog editor I get a
page with this:
Could not find Help page.
Unfortunately the Help page you selected was not found. The following data
could be helpful in locating the
error:
Help ID: text%2Fscalc%2Fguide%2Fcellstyle_conditional.
Message-ID: <[EMAIL PROTECTED]>
Date: Wed, 15 Nov 2006 14:46:34 +1100
From: Terry <[EMAIL PROTECTED]>
MIME-Version: 1.0
To: users@openoffice.org
Subject: Re: [users] Calc -Conditional formatting
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Hello Terry
Hello ,
Can anyone let me know how to change the font weight of a text in a Table -
Cell in Open Document Template based on a condition.
Basically i want the Cell value to be bold when the cell content starts with
'C#'
m: Andy Chaplin [mailto:perfect-engl...@gmx.de]
Sent: Wednesday, August 12, 2009 1:44 PM
To: users@openoffice.org
Subject: [users] Conditional Formatting
Hi everyone
I have a problem with conditional formatting in Calc.
I want to apply a style to a cell if the value in another cell meets a cer
2009/9/10 Keith Clark
> Is it not possible in Calc to conditionally change the background colour
> of a cell? I see that it is possible to change the text style, but I
> cannot find where/how to change the colour.
>
> Thanks,
>
> Keith
>
>
> It certainly is possible.
1. See the Help under Co
On Thu, 2009-09-10 at 14:59 +0100, Harold Fuchs wrote:
> 2009/9/10 Keith Clark
>
> > Is it not possible in Calc to conditionally change the background colour
> > of a cell? I see that it is possible to change the text style, but I
> > cannot find where/how to change the colour.
> >
> > Thanks,
>
At 17:30 26/09/2009 -0500, Wade Smart wrote:
My question is - I have 36 different cells to apply pretty much the
same conditional formatting to. Is there a way to do this without
doing it to each and every one?
Yes: you need just to select all the cells at once before you apply
the conditiona
2009/9/27 Brian Barker :
> At 17:30 26/09/2009 -0500, Wade Smart wrote:
>>
>> My question is - I have 36 different cells to apply pretty much the same
>> conditional formatting to. Is there a way to do this without doing it to
>> each and every one?
>
> Yes: you need just to select all the cells at
Wade Smart wrote:
> OMG!!! hours and hours of work done in like an hour :D
Great!
> ... My question is - I have 36 different cells to apply
> pretty much the same conditional formatting to. Is there a way to do
> this without doing it to each and every one?
My guess:
1. Select the cell with the
Le 28/08/2010 16:44, Andy Chaplin a écrit :
>
> Hi all
>
> As far as I can see it's only possible to have 3 levels of conditional
> formatting. Does anyone know of a trick or workaround to get more
> conditions to apply. Ideally i would like six and any suggestions
> would be gratefully apprecia
2010/8/28 Jean-Baptiste Faure :
> Le 28/08/2010 16:44, Andy Chaplin a écrit :
>>
>> Hi all
>>
>> As far as I can see it's only possible to have 3 levels of conditional
>> formatting. Does anyone know of a trick or workaround to get more
>> conditions to apply. Ideally i would like six and any su
On 08/28/2010 05:45 PM, Johnny Rosenberg wrote:
2010/8/28 Jean-Baptiste Faure:
Le 28/08/2010 16:44, Andy Chaplin a écrit :
Hi all
As far as I can see it's only possible to have 3 levels of conditional
formatting. Does anyone know of a trick or workaround to get more
conditions to
2010/8/28 Andy Chaplin :
> On 08/28/2010 05:45 PM, Johnny Rosenberg wrote:
>>
>> 2010/8/28 Jean-Baptiste Faure:
>>
>>>
>>> Le 28/08/2010 16:44, Andy Chaplin a écrit :
>>>
Hi all
As far as I can see it's only possible to have 3 levels of conditional
formatting. Does anyone
2010/8/28 Johnny Rosenberg :
> 2010/8/28 Andy Chaplin :
>> On 08/28/2010 05:45 PM, Johnny Rosenberg wrote:
>>>
>>> 2010/8/28 Jean-Baptiste Faure:
>>>
Le 28/08/2010 16:44, Andy Chaplin a écrit :
>
> Hi all
>
> As far as I can see it's only possible to have 3 levels of
On 08/28/2010 09:49 PM, Johnny Rosenberg wrote:
2010/8/28 Andy Chaplin:
On 08/28/2010 05:45 PM, Johnny Rosenberg wrote:
2010/8/28 Jean-Baptiste Faure:
Le 28/08/2010 16:44, Andy Chaplin a écrit :
Hi all
As far as I can see it's only possible to have 3 levels of
2010/8/29 Andy Chaplin :
> On 08/28/2010 09:49 PM, Johnny Rosenberg wrote:
>>
>> 2010/8/28 Andy Chaplin:
>>
>>>
>>> On 08/28/2010 05:45 PM, Johnny Rosenberg wrote:
>>>
2010/8/28 Jean-Baptiste Faure:
>
> Le 28/08/2010 16:44, Andy Chaplin a écrit :
>
>
>>
On 08/29/2010 11:35 AM, Johnny Rosenberg wrote:
2010/8/29 Andy Chaplin:
On 08/28/2010 09:49 PM, Johnny Rosenberg wrote:
2010/8/28 Andy Chaplin:
On 08/28/2010 05:45 PM, Johnny Rosenberg wrote:
2010/8/28 Jean-Baptiste Faure:
Le 28/08/2010 16:44, An
2010/8/29 Andy Chaplin :
> On 08/29/2010 11:35 AM, Johnny Rosenberg wrote:
>>
>> 2010/8/29 Andy Chaplin:
>>
>>>
>>> On 08/28/2010 09:49 PM, Johnny Rosenberg wrote:
>>>
2010/8/28 Andy Chaplin:
>
> On 08/28/2010 05:45 PM, Johnny Rosenberg wrote:
>
>
>>
>> 2
2010/8/29 Johnny Rosenberg :
> 2010/8/29 Andy Chaplin :
>> On 08/29/2010 11:35 AM, Johnny Rosenberg wrote:
>>>
>>> 2010/8/29 Andy Chaplin:
>>>
On 08/28/2010 09:49 PM, Johnny Rosenberg wrote:
>
> 2010/8/28 Andy Chaplin:
>
>
>>
>> On 08/28/2010 05:45 PM, Johnny
I found the solution – WITHOUT a macro and listeners and shit…!
I found it in one if the bug reports. It seems to be an undocumented feature.
Here's the steps to success, please tell me if this does not work:
1. Create the different styles, named the same as the possible cell
contents, I bel
2010/8/29 yahoo-pier_andreit :
>
>>
>> I found the solution – WITHOUT a macro and listeners and shit…!
>>
>> I found it in one if the bug reports. It seems to be an undocumented
>> feature.
>>
>> Here's the steps to success, please tell me if this does not work:
>>
>> 1. Create the different styles
2010/8/29 yahoo-pier_andreit :
>
>>
>> I found the solution – WITHOUT a macro and listeners and shit…!
>>
>> I found it in one if the bug reports. It seems to be an undocumented
>> feature.
>>
>> Here's the steps to success, please tell me if this does not work:
>>
>> 1. Create the different styles
> >
> > Using suse 11.3 ooo from suse (probably gooo) it doesn't work
>
> I am in OpenSUSE 11.2 right now (restarted my computer since last
> message) and my OpenOffice.org version is OOO310m21 (Build 9319) and
> it's the Novel version, I suppose that's the same as Go-OO, right?
>
> Anyway, my so
2010/8/29 Drew :
>> >
>> > Using suse 11.3 ooo from suse (probably gooo) it doesn't work
>>
>> I am in OpenSUSE 11.2 right now (restarted my computer since last
>> message) and my OpenOffice.org version is OOO310m21 (Build 9319) and
>> it's the Novel version, I suppose that's the same as Go-OO, rig
2010/8/29 Johnny Rosenberg :
> 2010/8/29 Drew :
>>> >
>>> > Using suse 11.3 ooo from suse (probably gooo) it doesn't work
>>>
>>> I am in OpenSUSE 11.2 right now (restarted my computer since last
>>> message) and my OpenOffice.org version is OOO310m21 (Build 9319) and
>>> it's the Novel version, I
> >
> > Howdy,
> >
> > Just tried the forumla technique above with Ubuntu 10.04 and the gooo
> > 3.2.1 from the 'proposed' repository - not sure when that is going to
> > roll to GA, but soon...anyway works like a charm here.
> >
> > Drew
>
> Sorry for my ignorance, but what is GA…?
Oh sorry - th
Il 29/08/2010 20:29, Johnny Rosenberg ha scritto:
2010/8/29 Drew:
Using suse 11.3 ooo from suse (probably gooo) it doesn't work
I am in OpenSUSE 11.2 right now (restarted my computer since last
message) and my OpenOffice.org version is OOO310m21 (Build 9319) and
it's the Novel version, I supp
2010/8/29 Drew :
>> >
>> > Howdy,
>> >
>> > Just tried the forumla technique above with Ubuntu 10.04 and the gooo
>> > 3.2.1 from the 'proposed' repository - not sure when that is going to
>> > roll to GA, but soon...anyway works like a charm here.
>> >
>> > Drew
>>
>> Sorry for my ignorance, but w
2010/8/29 yahoo-pier_andreit :
> Il 29/08/2010 20:29, Johnny Rosenberg ha scritto:
>>
>> 2010/8/29 Drew:
>
> Using suse 11.3 ooo from suse (probably gooo) it doesn't work
I am in OpenSUSE 11.2 right now (restarted my computer since last
message) and my OpenOffice.org version
Venky --
I don't fully understand what happened, but look into using absolute
references instead of relative references. You can check the help for
this information. If you need more help, let me know.
Peter
venky swaminathan wrote:
I have major doubt in using calc ... plz help me
issue is
Hi sir ,
thanks for helping me sir ,
the issue is
i have entered a data for 50 lines ( and i have put conditional
formating for all the 50 lines ) ...
then i insert a new row after 25 , after insertng the row
all the conditional formating is changed from 25th to 50th line ...
thanks for he
Venky --
I can't remember if I replied or not to this issue, but I would look
into using absolute reference instead of relative references.
HTH,
Peter
venky swaminathan wrote:
Hi sir ,
thanks for helping me sir ,
the issue is
i have entered a data for 50 lines ( and i have put conditiona
Colene Merrilda :
> Can anyone let me know how to change the font weight of a text in a Table -
> Cell in Open Document Template based on a condition.
> Basically i want the Cell value to be bold when the cell content starts with
> 'C#'
I've not used conditional formatting in OOo before today, bu
On 22/07/2008 15:54, Colene Merrilda wrote:
Hello ,
Can anyone let me know how to change the font weight of a text in a Table -
Cell in Open Document Template based on a condition.
Basically i want the Cell value to be bold when the cell content starts with
'C#'
Create a "style" having the
At 16:54 22/07/2008 +0200, Colene Merrilda wrote:
Can anyone let me know how to change the font weight of a text in a
Table - Cell in Open Document Template based on a condition.
If you really mean a table cell - a cell in table in a Writer
document, that is - then I don't see that there is an
I wanted to do this on a writer document. as Brian said.
On Tue, Jul 22, 2008 at 8:49 PM, Brian Barker <[EMAIL PROTECTED]>
wrote:
> At 16:54 22/07/2008 +0200, Colene Merrilda wrote:
>
>> Can anyone let me know how to change the font weight of a text in a Table
>> - Cell in Open Document Template
Can you do it in a Calc spreadsheet, then insert said spreadsheet into
the Writer document?
Colene Merrilda wrote:
I wanted to do this on a writer document. as Brian said.
On Tue, Jul 22, 2008 at 8:49 PM, Brian Barker <[EMAIL PROTECTED]>
wrote:
At 16:54 22/07/2008 +0200, Colene Merrilda w
I'm using neo office (open office 2.0.3 based), and I'm having difficulty
with conditional formatting.
I want the text in a cell to be red if the value in it is more than 10% over
the value in the neighboring cell.
So I do something like Cell Value, greater than, m5*1.1 (or whatever the
neighbor
Is conditional formatting possible in Writer? I am working on a
terminology assignment. Each term must have 3 definitions from 3
separate sources. As the document is growing quite long, it would be
wonderful to set up a visual clue as to which definitions have the
necessary number of sources
Hi,
I am trying to conditional format a cell in Calc. In excel, for
instance I can format a
cell to show a function result, if it is greater than 0 only. It goes
somethin like this IF(SUM(A1+B1)<=0;" ";SUM(A1+B1))
I tried this in Calc, but it just shows the formula, nothing else. Yes
I un chcheked
On Sunday, December 03, 2006 10:19 PM [GMT+1=CET], mpkirby
<[EMAIL PROTECTED]> wrote:
I'm using neo office (open office 2.0.3 based), and I'm having
difficulty with conditional formatting.
I want the text in a cell to be red if the value in it is more than
10% over the value in the neighboring
Joe Smith-4 wrote:
>
>
> First you have to define a named style. You can format a cell as you
> want it to look, then use the Stylist (F11) to define a style from the
> current cell. Give your style a name, e.g. "GE10".
>
> In the Format > Conditional Formatting dialog, choose "Cell Value" .
mpkirby wrote:
Joe Smith-4 wrote:
First you have to define a named style. You can format a cell as you
want it to look, then use the Stylist (F11) to define a style from the
current cell. Give your style a name, e.g. "GE10".
In the Format > Conditional Formatting dialog, choose "Cell Value
contender wrote:
>
>
>
> Conditional formatting recalculates normally.
>
> I found an instance where it does not. That was a case where the cell
> contained a formula referencing the last cell in a column. When the
> column was extended (so that, consequentially, a different cell became
mpkirby wrote:
contender wrote:
Conditional formatting recalculates normally.
I found an instance where it does not. That was a case where the cell
contained a formula referencing the last cell in a column. When the
column was extended (so that, consequentially, a different cell became
mpkirby wrote:
Okay more futzing. Turns out I have some complex macros, so I turned off
automatic updating. But at the time I was manually recalculating. It turns
out that manual recalculation does update macros, but not conditional
formatting.
Further, when you turn recalculation back on aga
Niklas Nebel wrote:
mpkirby wrote:
Okay more futzing. Turns out I have some complex macros, so I turned off
automatic updating. But at the time I was manually recalculating. It
turns
out that manual recalculation does update macros, but not conditional
formatting.
Further, when you turn re
Hello,
Is it possible to apply conditional formating to table cells in Writer?
The ODF specification does seem to allow for it.
--
Sander Marechal
Product Developer
[EMAIL PROTECTED]
Tribal Internet Marketing &
Internet MARKeting van Werven
Larenweg 24
5234 KA 's-Hertogenbosch
The Netherlands
At 16:05 21/11/2007 -0500, Henning von Roeder wrote:
I am trying to conditional format a cell in Calc. In excel, for
instance I can format a cell to show a function result, if it is
greater than 0 only. It goes something like this
IF(SUM(A1+B1)<=0;" ";SUM(A1+B1))
I tried this in Calc, but it ju
I am using Calc from the Novel Edition of OpenOffice.org 2.0 (build 2.0.0.1).
I want to eliminate all borders in certain cells when another cell contains the
text "Special Case" and in order to accomplish this, I defined a style
"borderless" using a blank cell in which I had eliminated all borde
On 21/08/07, Sander Marechal <[EMAIL PROTECTED]> wrote:
>
> Hello,
>
> Is it possible to apply conditional formating to table cells in Writer?
> The ODF specification does seem to allow for it.
>
> --
> Sander Marechal
> Product Developer
> [EMAIL PROTECTED]
>
> Tribal Internet Marketing &
> Intern
yes you can do that.
import a table from a folder.
then place it
From: "Harold Fuchs" <[EMAIL PROTECTED]>
Reply-To: users@openoffice.org
To: users@openoffice.org
Subject: Re: [users] Conditional formatting in Writer tables
Date: Wed, 22 Aug 2007 09:14:22 +0100
MIME-Versi
On 22/08/07, Yang Sean <[EMAIL PROTECTED]> wrote:
>
>
> yes you can do that.
>
> import a table from a folder.
>
> then place it
Huh?
--
Harold Fuchs
London, England
Please reply *only* to users@openoffice.org
Harold Fuchs wrote:
On 21/08/07, Sander Marechal <[EMAIL PROTECTED]> wrote:
Is it possible to apply conditional formating to table cells in Writer?
The ODF specification does seem to allow for it.
I don't know if it will do what you want but read the Help under
"Conditional Styles". It seems y
I have a spreadsheet which contains the results of exporting the
contents of a DB as a *.csv file.
A small number of the records repeat the value of one field, for
example, "companyname" while the other fields contain unique values
pertaining to that record. I need to be able to highlight the
Hi Jim,
James E. Lang wrote:
I am using Calc from the Novel Edition of OpenOffice.org 2.0 (build 2.0.0.1).
[...]
In cell AN2 I normally have 4.00 pt automatic color borders top and left. In
that cell I selected "Conditional formatting ..." from the "Format" menu. I
then selected Condition 1
Given that nobody has responded to this in the more than 72 hours that have
passed since I posted it I am going to assume that what I'm trying to do is so
exotic that nobody else on this list has ever tried it. Thus I now ask a new
question. Is there a better place to post my original message?
Hi James,
James E. Lang wrote:
Given that nobody has responded to this in the more than 72 hours that have
You've probably missed my post from 21:17 today, that has been deliverd
about one and a half hour ago.
Greetings,
Cor
--
Cor Nouws & Office
> www.NouEnOff.nl <
-
Hi Jim
Given that nobody has responded to this in the more than 72 hours that
have
passed since I posted it I am going to assume that what I'm trying to do
is so
exotic that nobody else on this list has ever tried it. Thus I now ask a
new
question. Is there a better place to post my origin
G. Roderick Singleton wrote at 7:36 on 16 Jul 2006:
> On Sat, 2006-07-15 at 14:41 -0700, James E. Lang wrote:
> > Given that nobody has responded to this in the more than 72 hours that have
> > passed since I posted it I am going to assume that what I'm trying to do is
> > so
> > exotic that no
On Sunday 13 March 2005 19:59, Doug Thompson wrote:
> I have a spreadsheet which contains the results of exporting the
> contents of a DB as a *.csv file.
>
> A small number of the records repeat the value of one field, for
> example, "companyname" while the other fields contain unique values
> per
Doug Thompson wrote:
The problem I'm having is that the address of the cell being tested
(flag) for Conditional Formatting doesn't change relative to the cell
being formatted when the formatting is copied. Thus, a test in B1 when
copied to B2 still evaluates cell A1. What I'm trying to find is
Hello,
I am making a small spreadsheet which does some calculations on given
data. However, I also have to share it with others who use MS Office. If
I save my ods sheet to MS Excel 2003 xml file, all the important stuff
works if somebody opens the xml file in MS Office 2003. However,
condit
On Jan 31, 2008 2:12 PM, Brian Barker <[EMAIL PROTECTED]> wrote:
> At 12:40 31/01/2008 -0500, you wrote:
> >... I also have to share it with others who use MS Office. If I save
> >my ods sheet to MS Excel 2003 xml file, ...
>
> Why are you using that format?
That is the only format that gets ope
69 matches
Mail list logo