Parentheses for Negative Percent Results - RESOLVED

[RAN_MPA]

I have been able to format single cells to display negative percents (Budget to Actual hours), but I cannot copy the formatting to cells with positive percents without eliminating the format style I want. [I need to display, with the parenthesis, (13.6%)for negative results, but say, 18.6% for positive results.] When I copy the correctly formatted cell (13.6%) to another cell with a positive result, it sets the display to general formating.

As I have over 25 rows of data to compare against 62 projects and 12 programs, with each value potentially changing from one analysis to the other, I am looking for a method to automatically change the "look" of the results.

I have looked at conditional formatting, but have had no indication this will do what I am looking for.

Any ideas on how to perform this task?

Thanks.

_________________
RAN_MPA
This message was edited by RAN_MPA on 2002-07-15 14:48

 

[zzydhf]

highlight the cells, right-click, format.
choose custom and paste this in the dialog box for "type": #,##0.0%;(#,##0.0%)

 

[RAN_MPA]

I almost had it; I left off one important element.

Thanks for your help.

 

[strussnat]

zzydhf -- thanks so much for that formula.
it totally saved me for this months reporting.

 

[pbowes]

Very nice - I've been looking for how to do that. Thanks!

 

[AnayaLiza]

Thank you for your help! Perfect answer to that question.

 

[Conroypi]

Thanks for the info!

You can also add Red to get negatives in red
#,##0.0%;[Red](#,##0.0%)