5 Replies Latest reply on Dec 20, 2012 10:09 AM by Tracy Rodgers

    Color format the Negative Numbers

    Jegan VelappanPillai

      Hi,

      My requirement looks simple but not able to achieve it with the properties I know of. My requirement is to highlight the Negative numbers in RED and Positive numbers in BLACK. I tried using the color marks but the problem is, the whole ROW is getting affected. What I need is only the Negative numbers needs to be highlighted in RED and not the Positive numbers, even though its in the same row.

       

      Expected Output:

      122560V Jegan34-1023
      12345Test 14023-40
      12567Test 232-23-45
      13456Test 3452245
      43567Test 450-90