colour problems

[cjjoo]

the problem i am facing now is that i wan to assign different colours t
cells that has the return value of "good", "ok" and "bad". is there
way to do that?

for instance,

in b2:b4, i got good, good, bad and okie. now i wan to colour the cell
according to their status.

good= green

okie =yellow

bad= red

can anyone help me with this

 

[David McRitchie]

You can use Conditional Formatting as long as you just have 3
colors being added by the conditions.
http://www.mvps.org/dmcritchie/excel/condfmt.htm
and if you have high speed access (Macromedia flash (swf) presentation)
http://www.datapigtechnologies.com/flashfiles/conditionalformatexcel.html

Your name and correct capitalization and spelling would be a lot
easier reading.