There is more than one solution here. When I need this, I apply two conditional formats to the same range of cells: When values below 0, set to red. When values above 0, set to red.