i have some data referring to % that comes in the format of 1.1% for a positive number and (1.1)% for a negative number

how can i get the 1.1% to display green and the (1.1)% to display red?

thanks in advance