Excel positives values to red

0

i need custom text format to highlight positive values to red. I see that there is custom format for negative values in red, but i cant figure out what should i do to highlight positive values to red.

Something like this is for highlighting negative values in red 

# ##0,00\ _€;[Red]-# ##0,00\ _€

thanks

ivanz

Posted 2015-07-08T09:41:24.223

Reputation: 109

try conditional formatting option if you using Excel-2010 or above – Prasanna – 2015-07-08T09:46:09.823

Answers

2

This will put positive values in red and negative in default color.

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

jcbermu

Posted 2015-07-08T09:41:24.223

Reputation: 15 868

The syntax is in the form of <positive value format>[;<negative value format>[;<zero value format>[;<string>]]] and therefore putting [Red] before the first semi-colon will make positive value red. – Kenneth L – 2015-07-08T10:12:04.427

Asked: 2015-07-08T09:41:24.223

Viewed: 628 times

Active: 2016-03-27T16:16:52.177