<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - VIEWING Cells with conditional formatting by formula not automatically updated after change of source value" href="https://bugs.documentfoundation.org/show_bug.cgi?id=137062#c2">Comment # 2</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - VIEWING Cells with conditional formatting by formula not automatically updated after change of source value" href="https://bugs.documentfoundation.org/show_bug.cgi?id=137062">bug 137062</a> from <a class="email" href="mailto:Stefan_Lange_KA@T-Online.de" title="Stefan_Lange_KA@T-Online.de <Stefan_Lange_KA@T-Online.de>"> Stefan_Lange_KA@T-Online.de</a> <pre>Many thanks for the hint to replace INDIRECT by INDEX! This solves my problem. I have a lot of documents with formulas containing INDIRECT. I will adapt them now step by step. I never was happy with the use of INDIRECT. Because of the handwritten adresses the formulas are hard to maintain in the case of neccessary changes and - as said in the hint - prone to errors.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>