Re: [users] Calc conditional formatting

On September 2, 2007, Joe Conner wrote: The dollar sign is used for absolute reference. If you want each new cell to have an adjusted reference then delete the dollar sign and then the reference will adjust as you seem to want. Ian Stephen wrote: Hi users I have a spreadsheet with

[users] Calc conditional formatting

Hi users I have a spreadsheet with conditional formatting references like Condition 1 Formula is If($D$20) Cell style X If I copy that either by copy and paste or by using the format paintbrush or fill-down to another row (say row 3), the reference remains $D$2 and I have to manually edit

Re: [users] Calc conditional formatting

The dollar sign is used for absolute reference. If you want each new cell to have an adjusted reference then delete the dollar sign and then the reference will adjust as you seem to want. Ian Stephen wrote: Hi users I have a spreadsheet with conditional formatting references like

[users] Calc -Conditional formatting

I have been struggling to make use of the Conditional Formatting facility, but as yet haven't achieved an accurate result. I have worked, step by step, through the example, in OOo Help (which is a very simple one) many times, but the result that occurs is pure nonsense. I am perfectly prepared

Re: [users] Calc -Conditional formatting

what you did, and what the result was, and maybe myself or someone else can help determine what is going wrong. -Original Message- From: [EMAIL PROTECTED] To: users@openoffice.org Sent: Tue, 14 Nov 2006 1:44 PM Subject: [users] Calc -Conditional formatting I have been

Re: [users] Calc -Conditional formatting

John, I'm surprised at what you say. I have been using conditional formatting in a spreadsheet for some time and it works a treat for me. I'm using it under WinXP SP2 with OOo2.0.4. I also used it with previous versions with no problems, except for the fact that the number of allowable

Re: [users] Calc -Conditional formatting

John Barman wrote: I have been struggling to make use of the Conditional Formatting facility, but as yet haven't achieved an accurate result. I have worked, step by step, through the example, in OOo Help (which is a very simple one) many times, but the result that occurs is pure nonsense. I

Re: [users] Calc: conditional formatting of #N/A

I don't see how that helps in highlighting NA's--it does all errors. --Tom Anthony Chilco wrote: What about using the iserror function? tc Tom Wainwright wrote: Pedro-- Thanks for the suggestion, but that doesn't solve the problem of being able to distinguish NA's from zero values. Recoding

Re: [users] Calc: conditional formatting of #N/A

On Thursday 31 March 2005 18:22, Thomas C. Wainwright wrote: Friends-- I am trying to use conditional formatting to highlight missing values (#N/A) in a numeric spreadsheet. The logical way of doing this would be to set a condition of cell value equal to na(). Unfortunately, while this

Re: [users] Calc: conditional formatting of #N/A

I hope this helps. I think that your problem was using the values true, false and NA. You can solve this with some cheating. True is 1 and False is 0, by logics. Place True equal to 2, by TRUE()+1=2, same applies to False, it will be FALSE()+1=1 Now you will not have the problem with the zero

Re: [users] Calc: conditional formatting of #N/A

What about using the iserror function? tc Tom Wainwright wrote: Pedro-- Thanks for the suggestion, but that doesn't solve the problem of being able to distinguish NA's from zero values. Recoding zeros as something else would rather mess up any statistics I'm running. ==Tom Pedro Santos wrote: