https://bugs.documentfoundation.org/show_bug.cgi?id=151817
--- Comment #5 from Dale Eltoft <[email protected]> --- Look closely at the Before and After images. In the Before the first two formulas begin like this "AND(P3<>0;O3>119;O3<130;P3<80)" The third & fourth they begin like this "AND(X3<>0;W3>119;W3<130;X3<80)" Notice that while the logic is identical but the variables (P,O & X,W) are different. Look at the After image which shows the conditions in the copy of the sheet from the Before. Here there are now only 2 conditions instead of four. The ranges have been combined to apply only the first set of formulas using only the variables that apply to the first pair to both ranges of cells. The second pair (#3 & #4) are missing. Consequently formatting of cells columns W & X is based on content of cells in columns P & O rather than the W & X content as is the case in the original sheet. -- You are receiving this mail because: You are the assignee for the bug.
