excel if, then...problem

[al_rwli]

Is it possible to have a cell's color changed depending on another cells
value?

For example...

We keep track of shipments coming in that are 1) either for customers
or "STOCK" 2) a certain amount of cubic footage.

This is what I'm inquiring...
Let's say that the cubic footage is anything over 20 could the
corresponding cell with the "Company's name" be changed to blue

And, if the customer is anything other than "STOCK" could it be changed
to yellow?
Attached is a copy of the form that we use....however we color the
cells ourselves. I'm just trying to make it easier for our accounts
personel.
Any help is greatly appreciated.
Thanks

Attachment filename: example list.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=650087

 

[Frank Kabel]

hi
use Format - Conditional Format' for this. See:
http://www.contextures.com/xlCondFormat01.html
http://www.cpearson.com/excel/cformatting.htm