https://bugs.documentfoundation.org/show_bug.cgi?id=153506
m.a.riosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |NOTABUG Status|NEEDINFO |RESOLVED --- Comment #6 from m.a.riosv <[email protected]> --- (In reply to bwilderhoo from comment #4) > Hi, > > Thanks for the feedback. Here is what you are missing (and it is a easy > thing to miss). The condition for range B18:M18 is to check the cell value > against the cell $Budget.$B23, whereas the condition for range B19:M19 is to > check the cell value against the cell $Budget.$B24. Basically, the first And it's what the new condition does. >..... > > For merged line that covers both rows with the range of B18:M19 the > condition is to check the cell value against the cell phone budgeted amount. > The electricity budgeted amount is lost in the merge. In fact, because the > conditions are checking against different budgeted amounts no merged single > condition can be used to cover both of the ranges. The two lines are I think it is not understood how the condicional format works. For a range, like B18:M19 it analyzes the conditions for every cell, varying accordingly the relative ranges in the conditions. E.g. for B18 -> $Budget.$B23 is analyzed, for B19 -> $Budget.$B24 is it. > mutually exclusive checks and ranges that need to remain as is, and not > merged when copied to a new sheet. If you want the ranges not to be merged, use an absolute reference also for the row $Budget.$B$23 This was done to reduce duplicated ranges with the same conditions. -- You are receiving this mail because: You are the assignee for the bug.
