Changing Font color automatically when Cell Format is Percentage

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Teljon - 18 May 2008 05:39 GMT

Excel 2007- How can I get the font color to change automatically to red when
I am using the Percentage Format in Cells and the answer is a negative
number? The dollar format works perfect but there is no option in the
percentage format to allow this to happen. I assume I have to use some
conditional formatting but I have not been able to find one that works and
it's driving me crazy. Is there anyone that can help with this problem??

Reply to this Message

Shane Devenshire - 18 May 2008 06:39 GMT

Hi,

you need to create a custom format.

here is one possible example: 0.00%;[Red]-0.00%

Choose Home, and click the quick launch button in the Numbers group, choose
Custom and enter the above on the Type line.

Cheers,
Shane Devenshire
Microsoft Excel MVP

> Excel 2007- How can I get the font color to change automatically to red
> when
[quoted text clipped - 3 lines]
> conditional formatting but I have not been able to find one that works and
> it's driving me crazy. Is there anyone that can help with this problem??

Reply to this Message