Conditional highlighting not working for “days from now” in numbers

Question

Mara2019 Author

Level 1

8 points

Conditional highlighting not working for “days from now” in numbers

I have OSX 10.14.3 and Numbers 5.3.

I have been working in Numbers using conditional highlighting to apply a colored fill to cells in date format. But whenever I add a rule and select the rule as "Date" then "Before..." or "Exactly...", then"4", "days from now" (any numbers, doesn't have to be 4), then click "Done" at the upper right conner:

then if I check this rule by clicking "Show Highlighting Rules", I find it automatically changes to "4 days ago" like this:

Is this a bug? Can anyone help me to fix it, or am I doing something wrong?

Thank you!

MacBook Pro 15", macOS 10.13

Posted on Mar 11, 2019 2:49 PM

Reply

Answer 1

Barry

Level 9

59,861 points

Mar 11, 2019 10:34 PM in response to Mara2019

Could be a bug, but if so, it appears to have been introduced after Numbers 3.6.2, which continues to show the rule correctly after several uses of Show Cobditional Highlighting Rules.

Regards,

Barry

Reply

Answer 2

Badunit

Level 7

25,940 points

Mar 11, 2019 7:11 PM in response to Mara2019

Happens here, too. Looks like a bug. The highlighting result remains correct but the rule is stated incorrectly.

Report it as a bug with Numbers/Provide Numbers Feedback. I did already but more reports are better.

Reply

Answer 3

Yellowbox

Level 7

20,383 points

Mar 11, 2019 11:42 PM in response to Mara2019

Hi Mara,

It looks like a bug in Numbers 5.3 (or earlier).

While we wait for Apple to fix it, see if this works for you.

Regards,

Ian.

Reply

Answer 4

Badunit

Level 7

25,940 points

Mar 12, 2019 4:40 AM in response to Yellowbox

From my testing. it does not affect how it works. I works the same as it was constructed but when you go to view it it tells it to you wrong.

Something else weird I noticed just now, not sure why I didn't notice it yesterday, is if I choose the rule "is before the date", I get "is before" and if I choose the rule "is before" I get "is before the date"

Reply

Answer 5

Mara2019 Author

Level 1

8 points

Mar 13, 2019 2:50 AM in response to Badunit

Thank you ! Yes as you said it seems to function well although it shows the rule wrong. But this bug can cause confusion when you need to make some adjustments to the rule and you check what rule is now being applied to the cell.

I noticed that wired thing too, although acceptable.

Reply

Answer 6

Yellowbox

Level 7

20,383 points

Mar 13, 2019 3:00 AM in response to Mara2019

Hi Mara,

Good catch! "Date is in the next 4 days" seems to behave itself. I must admit that I find conditional highlighting with dates a bit confusing.

Thanks for the green tick and your feedback.

Regards,

Ian.

Reply

Answer 7

Badunit

Level 7

25,940 points

Mar 13, 2019 4:53 AM in response to Yellowbox

It is a little confusing, with similar sounding rules that have different sub-rules to choose from and it is made worse by the rules being swapped; you choose one and get another. "Date is before" is swapped with "date is before the date", "date is after" is swapped with "date is after the date", and "date is exactly" is swapped with "is the date".

Reply

Answer 8

Mara2019 Author

Level 1

8 points

Mar 13, 2019 2:43 AM in response to Yellowbox

Thank you Ian. This does partially solve the problem. As an aside if one doesn't care about the dates before today, then could also use the rule "in the next 4 days":

Reply

Answer 9

Yellowbox

Level 7

20,383 points

Mar 13, 2019 6:34 AM in response to Badunit

Hi Badunit,

Yes, some confusion with swapping the rules. I have sent feedback to Apple., referencing this discussion.

Regards,

Ian

Reply

Conditional highlighting not working for “days from now” in numbers

Similar questions