I found that conditional formatting can not handle negative numbers both windows and macOS office versions. Even when I downgrade formula to as simple as >=-0.1 it can't get it. Screenshot
The cell format was set to numbers for the entire column - didn't helped.
I am pretty sure that numbers have minus sign and not dash because cell values are determined by Excel formula =N17-N16 and so on.
I explicitly copy/paste the minus sign from Excel formula into the conditional formatting rule - not worked as well.
The cell format was set to numbers for the entire column - didn't helped.
I am pretty sure that numbers have minus sign and not dash because cell values are determined by Excel formula =N17-N16 and so on.
I explicitly copy/paste the minus sign from Excel formula into the conditional formatting rule - not worked as well.