Hello,

I have created a conditional format that compares the previous cell to see if it is higher (green) or lower (red) or equal (Yellow).

I am having an issue where the previous cell is a "-" and the following cell is higher. It marks it as red instead of green.

How can i set only the conditional formatting to recognize "-" as 0.

I do not want to edit the main formulas because "-" is nullified and is not included in any calculations. Only wish to have Conditional formating recognize "-" as a 0


See picture attached

excel CF.JPG


Thanks!