Conditional format cell for $0

[Guest]

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 p10>0 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

 

[Guest]

set FormulaIS: =AND(W10=0,P10>0)

Set colour to Yellow

Or more generically for all cells in column W:

Highlight column W

FormulaIs: =AND(W1=0,P1>0)

HTH

 

[Guest]

Thank you, that was simple!! Another question I have is the qty value in my
material list auto copies over to my labor qty. Is there a way to have it
not put a 0 in the copied cell?

material qty is p10, labor qty is z10

z10 has the formula =p10 If there is text or a value in p10 it auto fills
beautifully, but if the p10 cell is blank then z10 has a 0. I would like to
have a blank unless p10 has something typed in it.

Thanks again

 

[Pete_UK]

Change the formula to this:

=IF(P10="","",P10)

Hope this helps.

Pete

 

[Guest]

=IF(P10="","",P10)