I am trying to apply a conditional format where if there is a stock item on hand in column I (i.e. value is greater than 0) and the price code hasn't been put in in column K (i.e. value is 0) then highlight cell.
I have been using this formula
=AND(I2>0,K2<=0)
but it doesn't seem to work. It is highlighting cells that don't meet this criteria and the ones where it does meet them, it is not picking it up.

Any thoughts?