https://communities.sas.com/t5/ODS-and-Base-Reporting/Zero-Values-Highlighted-in-Red-Formatting-Issue/m-p/45538#M6019 Oops realized I posted in the wrong forum. Please disregard. Tue, 07 Dec 2010 14:23:25 GMT deleted_user 2010-12-07T14:23:25Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Zero-Values-Highlighted-in-Red-Formatting-Issue/m-p/45537#M6018 I currently have a format that makes anything with a negative value red with ( ) around them. For the most part this works, but every once in a while there is a "positive" zero value that gets highlighted red. I am not sure why this is happening. Below is a sample of the code.<BR /> <BR /> Example of Format:<BR /> *********************************;<BR /> proc format;<BR /> value difffmt <BR /> -100000000 - 0.0001 = 'red';<BR /> picture NegDol (multilabel)<BR /> -100000000 - 0.00001 = '000,000,000,000)' (prefix='($')<BR /> 0.00001 - 100000000000 = '000,000,000,000' (prefix='$'); <BR /> <BR /> Example of what's being formatted:<BR /> Prcnt_Balance_Growth *f=percent7.2* [style=[foreground=difffmt.]] Tue, 07 Dec 2010 13:40:28 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Zero-Values-Highlighted-in-Red-Formatting-Issue/m-p/45537#M6018 deleted_user 2010-12-07T13:40:28Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Zero-Values-Highlighted-in-Red-Formatting-Issue/m-p/45538#M6019 Oops realized I posted in the wrong forum. Please disregard. Tue, 07 Dec 2010 14:23:25 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Zero-Values-Highlighted-in-Red-Formatting-Issue/m-p/45538#M6019 deleted_user 2010-12-07T14:23:25Z