https://bugs.documentfoundation.org/show_bug.cgi?id=115334
--- Comment #5 from Eric <[email protected]> ---
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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
