I linked data labels of one series to a column in the spreadsheet, then tried to custom format the labels so that negative numbers appear red in parentheses. The parentheses part worked, but negative number wouldn't turn red whatever I do. Can anyone help to solve this problem?

Thanks so much


------------