I'm trying to get an excel invoice to recognize negative numbers. I only have one condition running and it is "cell value is between -1000 and 1000" the format of the cell is currency, but it's still not recognizing negative numbers. can anyone help please!!!