set FormulaIS: =AND(W10=0,P100)

Set colour to Yellow

Or more generically for all cells in column W:

Highlight column W

FormulaIs: =AND(W1=0,P10)

HTH


"jerminski73" wrote:

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