I would like to set up a spreadsheet that, by default, uses one font for text and a separate font for numbers. I expect I would do this with styles but am not well versed in using styles. I would think that some number-crunchers out there have already solved this.
Thanks for the help,
Would View > Value highlighting (Ctrl+F8) be sufficient to differentiate? It does not affect printing.
Text is black, numbers are blue and formulas are green text
If you can do it using styles without any complications depends on the design and purposes ot the sheet(s).
If there is a set of cells (ranges) that will always present numbers (content or formula results), and another set always presenting text, you can doi it basically with two cell styles for which the respective font attributes are set differently.
If your sheet is a huge range of cells not specialized for one of the two cases, you can do it again wth two (or a few) cell styles, and one CondiotionalFormat setting.
If you need CF for different purposes, you need …
You see, I wouldn’t expect a reasonable answer as long as you not give more details.
A specific “conditional font” setting does not exist.
Value highlighting does really address the ideal solution. Certainly, it could be useful elsewhere, especially with bean-counting spreadsheets.
Lupp,
Cell styles is what I suspected is the answer. My spreadsheet is a patchwork of columns involving text and numbers being interspersed throughout the sheet.
I’ve done a little Conditional Formatting with limited success.
Implementing a new cell style and conditional formatting will likely see me back on this site asking how to questions.
One possibility would be conditional formatting using functions like ISTEXT()
https://wiki.documentfoundation.org/Documentation/Calc_Functions/ISTEXT
There are also ISNOTEXT() ISNUMBER()
You may have to decide how to handle special cases like postal codes, phone-numbers etc, wich look like numbers, but must often treated as text.
Thank you all for your help. I found “styles > auto-format styles” which is a possible solution to my situation. A drawback with this feature is that you must have a range that includes at least three contiguous rows/columns. That translates to a minimum of 9 cells highlighted before the “autoformat styles” command becomes active.
It seems that a new style is the best solution.