Description: Conditional formatting applied to a range of cells only works properly on a handful of those cells and misrepresents the status of others. Steps to Reproduce: 1.Create spreadsheet with an array of random values. Values should be 'Scientific' in nature. IE: 4.7e-6 2.Place a threshold value in a separate cell. IE: 3.1415e-3 3.Setup Conditional Formatting : Cell Value Is, greater than, (threshold cell location), enter some obvious style. 4.Click OK Actual Results: In the example spreadsheet: Cells B14,B15 and B16 are handled correctly. Cell B17 is incorrectly showing that the value is over the threshold. Similarly, cells C15 and C17 are incorrectly indicated, but C16 is correct. Etc. Expected Results: Expected to have values that were "greater than" cell B5 value to be highlighted, cells below or equal to the value should be displayed normally. Reproducible: Always User Profile Reset: Yes Additional Info: See Expected Results User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:58.0) Gecko/20100101 Firefox/58.0
Created attachment 140024 [details] Calc Spreadsheet Showing Malfunctioning Conditional Formatting
If you use absolute cell reference, eg. $B$5 instead of B5, then the conditional formatting will work as expected. While I have a tiny bit of doubt why it would be necessary when in this case conditional formatting references a value coming from a single source, the behavior seems to be consistent, so let's close this as NOTABUG.
I thought that I had tried that, but I see that it does work. I agree that this shouldn't be required. I don't know if this is the right place to suggest this, but there should be either a note about this in the Help file, and/or a note in the dialog where you enter the reference cell.