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 cell.
So I do something like Cell Value, greater than, m5*1.1 (or whatever
the neighboring cell is).
Suggestions? I've tried various formula variations as well, nothing
seems to work.
Mike
Not sure what is happening here. I'm using Win XP Pro/SP2 and OpenOffice
2.0.4 (the latest). I set cells in D1:D12 to be styled "Heading" if the
values were greater than 10 times the value of the corresponding cell in
C1:C12. It just works. I achieved it by choosing conditional formatting
for D1 and then copy/dragging D1 down to D12. Of course, the style has
to exist first because it has to appear in the drop down list within the
conditional formatting pane. So you can either create your own style or
modify, say, the existing style named "Result". I changed "Result" to
have font colour red and then set E1:E12 to be styled "Result" if the
values were >5*C1:C12 (I achieved the range by copy/drag as before).
This works too. The appropriate cells in E were displayed in red.
Please explain in detail what you have tried that didn't work and in
what way it didn't work - error message (what message) or other symptom
(what symptom).
Harold Fuchs
London, England
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
