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!
Bookmarks