[Libreoffice-bugs] [Bug 115334] variant Icon set in Conditional formatting cant be setup

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=115334

--- Comment #5 from Eric <erbenton at comcast.net> ---
I set the following:
=sign(k2-j98) in cell k98
This gives me 1 or -1 or 0 (not sure if i will ever get a zero but)
In conditional formatting Icon set, i set the yellow arrow to 0 and the green
to 1

The value in the cell is now -1 and a green arrow, it should be a red arrow

What i am trying to do is to track a changing value compared to a static value
I want to  see an appropriate icon if the dynamic value rises above or falls
below the static value, if its equal i should see a yellow

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180404/b01e7095/attachment.html>