Ask Your Question

Bubbe's profile - activity

2020-11-24 22:13:44 +0100 received badge  Famous Question (source)
2020-04-23 11:53:12 +0100 answered a question Bookmark fields not displaying contents

I feel stupid. Just realized I needed to select "Reference", not Chapter.

2020-04-23 11:50:36 +0100 asked a question Bookmark fields not displaying contents

Bookmark fields not displaying contents I am creating a document with bookmarks and then using cross reference. The fiel

2020-01-30 05:51:55 +0100 received badge  Notable Question (source)
2019-12-09 07:44:44 +0100 received badge  Popular Question (source)
2019-10-16 23:50:47 +0100 received badge  Famous Question (source)
2019-09-29 18:25:00 +0100 received badge  Popular Question (source)
2019-09-15 20:11:34 +0100 commented answer Is it possible to have a very complex conditional format?

I'm not certain I understand your reply. Are you saying the formula I wrote can be entered (piecemeal) in a conditional

2019-09-15 20:09:41 +0100 commented question Is it possible to have a very complex conditional format?

Thank you, but rulers don't display/use the decimal system. They are marked in fractional increments and when I'm cuttin

2019-09-15 20:09:23 +0100 commented question Is it possible to have a very complex conditional format?

Thank you, but rulers don't display/use the decimal system. They are marked in fractional increments and when I'm cuttin

2019-09-15 20:07:00 +0100 marked best answer Is it possible to have a very complex conditional format?

I often use Calc for my sewing. A lot of my projects only vary by dimension, but the cutting, layout and assembly is all the same. That being said, my values tend to be in fractions. However, a single fraction format does not work for me because sometimes a value can be multiples of 1/16, 1/8, 1/4 or 1/2. I want the formatting to reflect the appropriate formatting.

Consider this:
image description

I have created a formula (below) which correctly identifies the desired formatting based on the user input (in the image it's the last cell at the bottom.)

The question is: how can I apply this to the field where the entry is being made (where it's labeled "Enter Value")?

My formula: image description

where:
inValue is the user input
x4th=100
x8th=1000
x16th=10000

Realized afterwards an example of what I'm doing may be useful in understanding what's going on. The spreadsheet image below is for making a cover for a spiral notebook with an attached pencil pouch.

The values wanted are entered in the yellow cells with red text. It's one of the places I would also want to apply conditional formatting and not have to edit by hand every time.

image description

2019-09-15 20:07:00 +0100 received badge  Scholar (source)
2019-09-15 20:06:45 +0100 commented answer Is it possible to have a very complex conditional format?

Thank you. I have no idea how I missed such a simple solution. Just tried it and it worked handsomely!

2019-09-15 14:20:13 +0100 received badge  Notable Question (source)
2019-09-15 05:47:12 +0100 received badge  Popular Question (source)
2019-09-14 22:16:47 +0100 edited question Is it possible to have a very complex conditional format?

Is it possible to have a very complex conditional format? I often use Calc for my sewing. A lot of my projects only vary

2019-09-14 22:15:58 +0100 edited question Is it possible to have a very complex conditional format?

Is it possible to have a very complex conditional format? I often use Calc for my sewing. A lot of my projects only vary

2019-09-14 21:59:04 +0100 asked a question Is it possible to have a very complex conditional format?

Is it possible to have a very complex conditional format? I often use Calc for my sewing. A lot of my projects only vary

2019-08-07 05:11:31 +0100 answered a question Calc: Defined cell names not displaying in the name box

I have figured out part of the problem. When I changed the "Scope" to the current worksheet (named "Spiral") is when the

2019-08-07 04:27:13 +0100 edited question Calc: Defined cell names not displaying in the name box

Defined cell names not displaying in the name box I have created a worksheet in which I have defined names for a lot of

2019-08-07 04:27:13 +0100 received badge  Editor (source)
2019-08-07 04:24:01 +0100 edited question Calc: Defined cell names not displaying in the name box

Defined cell names not displaying in the name box I have created a worksheet in which I have defined names for a lot of

2019-08-07 04:20:14 +0100 asked a question Calc: Defined cell names not displaying in the name box

Defined cell names not displaying in the name box I have created a worksheet in which I have defined names for a lot of