if condition to change cell color

Originally Posted by pantea

Hi
please help me.
i have some condition to change color of the cell in a column.
in a table if price is 14000 the color of cell must be change to red if its price is more than 30000 it must be change to green color and otherwise change to blue!

how can i set this conditions ?!
I am not master in excel please help and definite how can i do!
thanks
cheers

Try conditional formatting
http://www.cpearson.com/excel/cformatting.htm