https://bugs.documentfoundation.org/show_bug.cgi?id=162619
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |NEW Resolution|NOTABUG |--- Ever confirmed|0 |1 --- Comment #3 from ady <[email protected]> --- (In reply to m_a_riosv from comment #2) > The condition is always false. I don't understand what you mean. If I change cell B8 to "YES", then the condition results in FALSE, so the CF should react and change the background color of B1:B7. But, in order to actually see the change, you have to scroll that range out of the screen and scroll back to it, which is what the OP reported in comment 0. It is true that the formula in the CF for cells B1:B7 seems over-complicated, but that is not the point. The point is that the screen is not immediately refreshed with the CF result. One detail: if the cells B1:B7 contain the formula (from the CF dialog) =INDIRECT(ADDRESS(ROW()+MATCH("X";INDIRECT(ADDRESS(ROW();1;4)&":"&ADDRESS(ROW()+16;1;4));0)-1;COLUMN();2;1))="NO" then the reaction on screen is immediately seen as soon as cell B8 is changed from NO to YES; there is no need to scroll in such case. -- You are receiving this mail because: You are the assignee for the bug.
