Hi all
I would like to highlight cells is two conditions are met:
- Cell = 0
- Offset(0,-1)>0
I tried the conditional format wizard and entered a formula:
=IF(AND($J2=0,$I2>0))
But I keep receiving formual errors, which I understand, because it appears to be incomplete formula. But I am not sure what else I need to add to the formula in the conditional format wizard
TIA
Best regards,
-markc