In A1, Conditional formating..
Select 'Formula is' (default is 'cell value is')
Enter condition as A2>100. Select the required cell type format.
Hope this will work for you. I tried this with OOo 3.1 & Windows XP & is
working.
Ashish
-Original Message-
From: Andy Chaplin [mailto:perfect-
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
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
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
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
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
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
54 matches
Mail list logo