none
Green Parentheses in Excel 2010?

    Question

  • Is there a way to format a section of an Excel report with green parentheses to indicate that a decrease in expenses is a positive thing?

    Douglas R. Eckert

    Wednesday, September 18, 2013 3:13 PM

Answers

All replies

  • Hi,

    Did you want to make the cell include "(XXX)" turn green? If you want this, please use Conditional Formatting command.

    You can custom the role which the text include "(XXX)" and color.  Please refer to the following steps:

    Click Home Tab>Choose Conditional Formatting>New Role>Format only cells that contain>Specific Text>Include> ()>Choose the range 

    For more detail information, please refer to the following link:

    http://office.microsoft.com/en-us/excel-help/use-a-formula-to-apply-conditional-formatting-HA102809768.aspx

    http://office.microsoft.com/en-us/excel-help/add-change-find-or-clear-conditional-formats-HA102749062.aspx?CTT=5&origin=HA102809768

    Regards,

    George Zhao
    TechNet Community Support

    Thursday, September 19, 2013 9:45 AM
  • George:  Thank you for the reference page.  I have saved it to use in the future.

    In this case, I had hoped to find a way to use conditional formatting on just the parentheses themselves.  It appears there is not a way to do so.

    Doug in York PA


    Douglas R. Eckert

    Thursday, September 19, 2013 11:21 AM
  • Hi,

    Here is way to color only the cell content. please refer to the steps with the following link:

    http://www.techonthenet.com/excel/questions/cond_format1_2010.php

    Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

    If you only need to color the parentheses, I recommend we use a macro and you can post the question to MSDN forum.

    http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

    George Zhao
    TechNet Community Support

    Friday, September 20, 2013 1:25 AM