I have a worksheet with columns formatted to total in RED if negative & BLACK if positive. However, despite redoing time & time again, although the total is positive, the colour of the text is PURPLE? All surrounding cells are formatted correctly. Why cant I get rid of this PURPLE?
Bookmarks