Thanks Hui... I have read both these sections however unfortunately doesnt help me with what i am looking to do..... See my above blog which explains what I am looking to do
I tried it, I am not very good in excel....
When I tried conditional formatting it only allows 3 conditions to be added whilst I need nearly 7 and I use excel 2003. Also, I am not sure if I am doing it right as it colors the field status instead of defect ID.
What I am loking for is that it...
How do I change the color of a cell based on a dynamic value in another cell.
e.g.
Defect ID Status
11 New
12 Assigned
So if the value in Status field is New change the color of 11 to Yelllow and so on....