https://bugs.documentfoundation.org/show_bug.cgi?id=174303
--- Comment #4 from ady <[email protected]> --- (In reply to Heiko Tietze from comment #3) > (In reply to othniel from comment #2) > > "No other software support this." > > why limit calc to other peoples imaginations? > > Please elaborate. Conditional formatting is the usual way to format a cell > depending on content. What other tool provides access to the cell background > color? I cannot imagine a function that does the trick. With CF, you can define ranges of values / scales. Although that is not exactly the same as one rule per value, it could help in several cases. As an alternative (but not necessarily recommended, YMMV), Calc has the STYLE() function. You would not need CF rules, but you still need to define relevant styles for each case. The styles could be defined by value, or by using other functions such as CELL() or INFO(). -- You are receiving this mail because: You are the assignee for the bug.
