Re: [libreoffice-users] Is This Possible In Calc?

2015-02-09 Thread Tom Davies
Hi :) I like it when a few different people all give basically the same answer but say it in different ways and with different levels of detail. It gives more confidence in the answer. Different people respond better to different styles of answer. I vaguely remember this question being asked abo

Re: [libreoffice-users] Is This Possible In Calc?

2015-02-07 Thread Luuk
On 7-2-2015 18:58, Kolbjørn Stuestøl wrote: Well, I posted my e-mail before the other answers showed up. But I agree with you, Tom. This is *the* link if you needs help or some tips using LibreOffice. Kolbjoern Den 07.02.2015 17:23, Tom Davies skreiv: Hi :) I like it when a few different peopl

Re: [libreoffice-users] Is This Possible In Calc?

2015-02-07 Thread Dave Barton
First a big thank you to all who took the time to answer. I started out (many hours ago) trying unsuccessfully to work out a solution with conditional formatting, which is why I changed direction to the IF formula in cell A1. The real world situation is way more complex than I previously explaine

Re: [libreoffice-users] Is This Possible In Calc?

2015-02-07 Thread Kolbjørn Stuestøl
Well, I posted my e-mail before the other answers showed up. But I agree with you, Tom. This is *the* link if you needs help or some tips using LibreOffice. Kolbjoern Den 07.02.2015 17:23, Tom Davies skreiv: Hi :) I like it when a few different people all give basically the same answer but say

Re: [libreoffice-users] Is This Possible In Calc?

2015-02-07 Thread Kolbjørn Stuestøl
Den 07.02.2015 16:14, Dave Barton skreiv: I don't believe the following is possible, but I hope some Calc guru (Brian?) here can prove me wrong. To have a formula in cell A which evaluates the contents of cell B and changes the style, but NOT the content, of cell C. eg. A1=contains the formula,

Re: [libreoffice-users] Is This Possible In Calc?

2015-02-07 Thread Brian Barker
At 16:14 07/02/2015 +0100, Dave Barton wrote: I don't believe the following is possible, but I hope some Calc guru (Brian?) here can prove me wrong. I'm not sure I'm a guru, but here goes: To have a formula in cell A which evaluates the contents of cell B and changes the style, but NOT the co

Re: [libreoffice-users] Is This Possible In Calc?

2015-02-07 Thread Jay Lozier
On 02/07/2015 10:14 AM, Dave Barton wrote: I don't believe the following is possible, but I hope some Calc guru (Brian?) here can prove me wrong. To have a formula in cell A which evaluates the contents of cell B and changes the style, but NOT the content, of cell C. eg. A1=contains the formula

Re: [libreoffice-users] Is This Possible In Calc?

2015-02-07 Thread Luuk
On 7-2-2015 16:14, Dave Barton wrote: I don't believe the following is possible, but I hope some Calc guru (Brian?) here can prove me wrong. To have a formula in cell A which evaluates the contents of cell B and changes the style, but NOT the content, of cell C. eg. A1=contains the formula, B1=0

[libreoffice-users] Is This Possible In Calc?

2015-02-07 Thread Dave Barton
I don't believe the following is possible, but I hope some Calc guru (Brian?) here can prove me wrong. To have a formula in cell A which evaluates the contents of cell B and changes the style, but NOT the content, of cell C. eg. A1=contains the formula, B1=0, C1=20 Pseudo Code for cell A1: =IF(B1=