https://bugs.documentfoundation.org/show_bug.cgi?id=154750
--- Comment #11 from ady <adylo811...@gmail.com> --- (In reply to Darrell O'Brien from comment #10) > The steps for conditions select cell, format condition popup screen equal to > (fixture sheet and corresponding cell set colour to excel 8.2.1 add > condition repeat for second condition. press ok. Your descriptions are not easy to understand. I am guessing now... In your attachment 186601 from comment 4, in worksheet "enter tips", all the conditional formats in that worksheet are of the form "Cell value" > "is equal to" and then you use some cell from the "FIXTURE" worksheet. This seems incorrect. "Cell value" > "is equal to" expects a value, not a formula pointing to another cell. In the conditional format dialog, you would need to select "Formula is" and then enter the formula in the next field (e.g. "=$FIXTURE.$B$11" without quotation marks). This is all based on a guess of what you might be trying to say. Please confirm whether this matches your expectations. If it isn't, then please explain in detail (step by step): 1. Which worksheet (tab) we should click on. 2. Which cell in that worksheet we should click on. 3. Which exact action we should perform next. 4. What is the current behavior. 5. What was the expected behavior. Up until this point, I don't understand what this report is about. -- You are receiving this mail because: You are the assignee for the bug.
