Ask Your Question

FBachofner's profile - activity

2019-08-27 14:13:07 +0100 received badge  Famous Question (source)
2019-08-27 14:13:07 +0100 received badge  Notable Question (source)
2019-05-20 23:32:04 +0100 received badge  Famous Question (source)
2018-12-21 03:07:50 +0100 commented answer How to NOT graph empty cells [closed - with note to Calc developers in answer]

@erAck I's funny you point this out; in my own implementation I actually did use the IF(ISBLANK(A1) construct! :-) I

2018-12-21 03:07:50 +0100 received badge  Commentator
2018-12-18 22:41:43 +0100 received badge  Notable Question (source)
2018-12-18 20:05:53 +0100 received badge  Popular Question (source)
2018-12-18 17:25:16 +0100 edited question How to NOT graph empty cells [closed - with note to Calc developers in answer]

How to NOT graph empty cells I am making something like a "dashboard" in Calc. Each day a new value gets added to the n

2018-12-18 17:24:44 +0100 edited answer How to NOT graph empty cells [closed - with note to Calc developers in answer]

OK . . . My question was oversimplifying the actual usage. The range for the graph is not just a numeric entry. It is

2018-12-18 06:10:02 +0100 edited answer How to NOT graph empty cells [closed - with note to Calc developers in answer]

OK . . . My question was oversimplifying the actual usage. The range for the graph is not just a numeric entry. It is

2018-12-18 06:07:42 +0100 answered a question How to NOT graph empty cells [closed - with note to Calc developers in answer]

OK . . . My question was oversimplifying the actual usage. The range for the graph is not just a numeric entry. It is

2018-12-18 05:52:40 +0100 edited question How to NOT graph empty cells [closed - with note to Calc developers in answer]

How to NOT graph empty cells I am making something like a "dashboard" in Calc. Each day a new value gets added to the n

2018-12-18 05:51:59 +0100 edited question How to NOT graph empty cells [closed - with note to Calc developers in answer]

How to NOT graph empty cells I am making something like a "dashboard" in Calc. Each day a new value gets added to the n

2018-12-18 05:51:25 +0100 edited question How to NOT graph empty cells [closed - with note to Calc developers in answer]

How to NOT graph empty cells I am making something like a "dashboard" in Calc. Each day a new value gets added to the n

2018-12-18 05:49:35 +0100 commented question How to NOT graph empty cells [closed - with note to Calc developers in answer]

Interesting: If I delete the formula in the "blank" cells, the graph properly omits displaying the missing values as "ze

2018-12-18 05:46:45 +0100 edited question How to NOT graph empty cells [closed - with note to Calc developers in answer]

How to NOT graph empty cells I am making something like a "dashboard" in Calc. Each day a new value gets added to the n

2018-12-18 04:58:27 +0100 asked a question How to NOT graph empty cells [closed - with note to Calc developers in answer]

How to NOT graph empty cells I am making something like a "dashboard" in Calc. Each day a new value gets added to the n

2018-12-18 04:41:00 +0100 commented answer How can I add conditional formatting based on values being <, >, or between other cell values

@Mike Kaganski The "less than or equal to" and "less than" conditions are, indeed, ultimately the way I "finished" my c

2018-12-18 04:35:45 +0100 commented answer How can I add conditional formatting based on values being <, >, or between other cell values

@robleyd I didn't say "original," just elegant. ;-) Adding to my embarrassment, the way I laid it out is pretty much

2018-12-10 18:24:09 +0100 received badge  Popular Question (source)
2018-12-10 07:43:04 +0100 commented answer How can I add conditional formatting based on values being <, >, or between other cell values

sorry, inadequate karma to upvote I hope others will, your solution is really elegant!

2018-12-10 07:42:52 +0100 commented answer How can I add conditional formatting based on values being <, >, or between other cell values

sorry, inadequate karma to upvote I hope others will, the solution is really elegant!

2018-12-10 07:42:41 +0100 commented answer How can I add conditional formatting based on values being <, >, or between other cell values

sorry, inadequate karma to upvote I hope others will, the solution is really elegant!

2018-12-10 07:40:44 +0100 marked best answer How can I add conditional formatting based on values being <, >, or between other cell values

I have a "legend" on a Calc sheet with 5 different values in 5 cells.

for example:

A1 = 4.9
A2 = 5
A3 = 10
A4 = 15
A5 = 20

I want to apply conditional formatting to a range as follows (psuedo code):

condition 1: IF <A1
condition 2: IF >=A2 AND <A3
condition 3: IF >=A3 AND <A4
condition 4: IF >=A4 AND <A5
condition 5: IF >=A5

Unfortunately I am getting stuck entering any useful formula in the "formula-is" of each condition in the conditional formatting dialog.

Thanks in advance for any guidance.

2018-12-10 07:40:44 +0100 received badge  Scholar (source)
2018-12-10 07:40:08 +0100 commented answer How can I add conditional formatting based on values being <, >, or between other cell values

@robleyd Thanks, that's awesome! A1 is (for the moment) actually anything less then "5" (i.e. value at A2) -- I just

2018-12-10 07:39:45 +0100 commented answer How can I add conditional formatting based on values being <, >, or between other cell values

@robleyd Thanks, that's awesome! A1 is (for the moment) actually anything less then "5" (i.e. value at A2) -- I just

2018-12-10 02:55:32 +0100 asked a question How can I add conditional formatting based on values being <, >, or between other cell values

How can I add conditional formatting based on values being <, >, or between other cell values I have a "legend" on

2018-12-10 02:32:56 +0100 received badge  Famous Question (source)
2017-12-30 11:47:54 +0100 received badge  Notable Question (source)
2017-12-19 00:51:12 +0100 commented answer How can I add hard return (i.e. newline) to conditional text field in LO Writer MailMerge

It's entirely possible David never received (automatic) notification his submission received any response. That's happe

2017-12-18 23:03:10 +0100 received badge  Popular Question (source)
2017-12-18 17:27:08 +0100 edited question How can I add hard return (i.e. newline) to conditional text field in LO Writer MailMerge

How can I add hard return (i.e. newline) to conditional text field in LO Writer MailMerge I dislike the inbuilt method f

2017-12-18 17:26:41 +0100 commented answer How can I add hard return (i.e. newline) to conditional text field in LO Writer MailMerge

Reference? Here's just one of a great many I have found. David points out how illogical suppressing blanks is and even

2017-12-18 17:18:17 +0100 commented answer How can I add hard return (i.e. newline) to conditional text field in LO Writer MailMerge

I'm editing my original question, because it is not just the "skipping fields issues" with which people have an issue.

2017-12-18 17:14:15 +0100 commented answer How can I add hard return (i.e. newline) to conditional text field in LO Writer MailMerge

Doing it "at the paragraph side" is "logical" if you think suppressing a whole bunch of empty paragraphs makes sense. K

2017-12-15 10:09:00 +0100 edited question How can I add hard return (i.e. newline) to conditional text field in LO Writer MailMerge

How can I add hard return (i.e. newline) to conditional text field in LO Writer MailMerge I dislike the inbuilt method f

2017-12-15 10:09:00 +0100 received badge  Editor (source)
2017-12-15 10:05:40 +0100 edited question How can I add hard return (i.e. newline) to conditional text field in LO Writer MailMerge

Ho can I add hard return (i.e. newline) to conditional text field in LO Writer MailMerge I dislike the inbuilt method fo

2017-12-15 10:05:20 +0100 asked a question How can I add hard return (i.e. newline) to conditional text field in LO Writer MailMerge

Ho can I add hard return (i.e. newline) to conditional text field in LO Writer MailMerge I dislike the inbuilt method fo