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

Markus Mohrhard <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #1 from Markus Mohrhard <[email protected]> ---
The case with a formula does not work as you think.

The formula is evaluated and checked if it returns true or false. Not if the
current cell can be evaluated against the current cell.

You can of course use a relative reference to the current cell in the formula
which gives you the result that you want.

Have a look at
https://support.office.com/en-au/article/Use-a-formula-to-apply-conditional-formatting-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f
and other documentation for conditional formatting with formulas.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to