Hey Gang:
Have the following formula in a cell
=IF(J38=J42,“ABOVE TOTALS MATCH”&T(STYLE(“GOOD”)),“TOTALS DO NOT MATCH”&T(STYLE(“Bad”)))
I want to make the text BOLD. Tried the obvious by making the cell BOLD, but as the values change, I loose the BOLD.
How do I accomplish making the displayed text BOLD?
Thanks,
Rich Ramik
do the obvious changes on the Styles "GOOD" and|or respectivly "Bad"
Well, this is not what the boss asked for. Sorry.
Then, if your boss don’t want that cell styles Good and Bad be bold, create new cell styles inherited from Good and Bad.
Why? If the cell calculates a formula anyway, you can add some STYLE to your formula. In both cases you have to change the cell style in order to change the appearance.
The original line is provided above. I have been searching and testing to no avail. Where do I place “BOLD”???
Yes you can. It’s bad anyway. All STYLE() modifications encountered need to be applied whenever a formula is recalculated, i.e. the sheet is modified during recalculation (luckily only the styling, not the content). That also happens for formulas in cells that are not currently visible but need to be recalculated due to dependencies or because they contain volatile functions. Conditional formats are primarily only evaluated and applied for currently visible cells, for the remaining only after that in background idling. Furthermore, the STYLE() function is LibO/OOo only and not compatible with other spreadsheet applications.