Conditional Formula
 

I have created a spreadsheet were you can type a quantity next to a part
description and price. Is there a formula that will automatically color
fill the cell containing the description of the part if the value of the
quantity column is greater than 0?

Thanks in advance!


--
rdaled
------------------------------------------------------------------------
rdaled's Profile: http://www.excelforum.com/member.php...o&userid=37603
View this thread: http://www.excelforum.com/showthread...hreadid=572251

Conditional Formula
 

What you're looking for is Conditional Formatting. if you select the
cell with the description in it and select Format\Conditional
Formatting... and then select "Formula Is" from the drop down box in
the upper left of the dialog box and type in this formula (assuming
your description is in B1 and the Quantity is is A1) =A1<0

then select the formatting you want and when A1 is NOT zero your cells
will be formatted the way you want.


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=572251

Conditional Formula
 

Works like a charm! Many thanks!!

Quick, accurate answer. I am definitely book-marking this site!!!


--
rdaled
------------------------------------------------------------------------
rdaled's Profile: http://www.excelforum.com/member.php...o&userid=37603
View this thread: http://www.excelforum.com/showthread...hreadid=572251