Conditional Formatting

[Ian1976]

Morning,

I have a cell which is formatted so when it goes into - (minus) figures it turns the cell red, i also have a drop down menu which if "X" is selected from the drop down menu it makes the cell display an "E" with a Green fill, my problem is that when the number is showing minus and i select "X" from the drop down i'm getting the E but with a minus next to it?

Is it possible to drop the minus next to the "E" when I select X from the drop down menu? I've tried playing with the priorities of the formats but I can't seem to get it to work?

Thanks

 

[JackDanIce]

I would use cell formatting for this, not conditional formatting, where the custom format is:

[Blue]#,##0;-[Red]#,##0;-;@

Each ; separates between: {format for positive value}<format positive="" number="">; {format negative val}<format neg="" number="">; {format for 0}<format for="" 0="">; {format for text}
<format for="" text="">Where @ is "General" (I think)</format></format></format></format>

 

[Ian1976]

Thanks but I've never come across doing this using that formula? Could you give me an example if the negative number is in I8 and my drop down is in E8 how do i implement that?

Thanks

 

[JackDanIce]

In Google: "Excel custom cell formats" returns:
https://www.google.com/search?q=exc...7j69i60j0l4.3198j0j7&sourceid=chrome&ie=UTF-8

When you right click on a cell, there is an option for cell formatting. Within this, are different formats, including custom and you add the suggested one to the custom list.

It's the difference between the true value the cell contains vs the number it displays. E.g. 1.5 and £1.50 are the same number, but one is represented as a mixed number, the other as a currency formatted number.

 

[Ian1976]

Thank you! ??