https://bugs.documentfoundation.org/show_bug.cgi?id=153506
--- Comment #4 from [email protected] --- 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 range is simply checking the recorded monthly cell phone expense against the cell phone budgeted amount and highlighting yellow if expense amount exceeds budgeted amount. Similarly, for the second range, but the check is against the budgeted electricity amount. 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 mutually exclusive checks and ranges that need to remain as is, and not merged when copied to a new sheet. Hope this helps. Please confirm that you are seeing what I have described above. Thanks for your help. -- You are receiving this mail because: You are the assignee for the bug.
