ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Font color incorrect (https://www.excelbanter.com/excel-discussion-misc-queries/210407-font-color-incorrect.html)

DocBrown

Font color incorrect
 
I have a cell with sum formula for a range of cells that are formatted as
currency. I have the cell format set to currency with negative number red
with parenthesis. For sum reason, when I first set it and the sum is neg, the
cell font is red. But later when I make it go positive then back negative, it
turns blue. What could be causing this? I've deleted and reset the cell to
try and insure there's no unexpected settings.

I've had font color problems in Access also where the font is not displayed
in the expected color. Is there something else in Office or on my system that
could be mucking with the font color? I'm on WinXP Pro SP3, w/ Office XP.

Thanks,
John


All times are GMT +1. The time now is 04:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com