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
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
I'm assuming that you have numeric data formatted as percentage, with parentheses for negative values.
Create a new conditional formatting rule using "Format only cells that contain" and then specify "Cell value less than 0" for the red, and another rule that is "Cell value greater than or equal to 0" formatted green.
(If your data is instead text data, then the rules would be different, but that would also not be a good practice.)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks