[$$-409]* #,##0.00;[RED][$$-409]* (#,##0.00)
I have the above coding to create a preferred currency format in USD. Everything is working except the font color. My negative values are displaying in blue, not red. I am not sure how to fix this. Thanks for any help
Please upload your ODF type sample file here.
Just switch OFF the Value Highlighting function in the View menu.
It shows you the type of the cell contents in different colors: Number/Text/Formula.
Thank you for your help. I am not familiar with value highlighting selection. I’ll read up a bit more on it. I knew I was doing something wrong. Also have to learn to use the styles feature. I can not get my default currency to assign to the currency icon automatically. I want that format for all currency fields in my spreadsheets.