--- Comment #6 from Markus Mohrhard <> ---
(In reply to Eric from comment #5)
> 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

Please attach a test document with detailed instructions how to reproduce the

You are receiving this mail because:
You are the assignee for the bug.
Libreoffice-bugs mailing list

Reply via email to