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

for instance,

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

good= green

okie =yellow

bad= red

can anyone help me with this?


--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=401397