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

Improve this question
1
  • try conditional formatting option if you using Excel-2010 or above
    – Prasanna
    Jul 8, 2015 at 9:46

1 Answer 1

Reset to default
2

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

[Red]#,##0;-#,##0
Improve this answer
1
  • 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
    Jul 8, 2015 at 10:12

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .