Conditional format cell for $0
 

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

Conditional format cell for $0
 

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

Conditional format cell for $0
 

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

Conditional format cell for $0
 

Change the formula to this:

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

Hope this helps.

Pete


On Apr 19, 3:36 pm, jerminski73
wrote:
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

Conditional format cell for $0
 

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

"jerminski73" wrote:

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