I have many cells in which the special order price of an item needs to be
manually entered. I would like to conditional format the "cost" if the cost
= $0 and there is a qty greater than 0.


w10=0 and p100 turn yellow
ie, Cost is zero but qty to sell is not zero turn cell yellow, if no qty
then cell remains normal color.

Thanks in advance
Jeremy