GANT TOOL no.2

[_ratS]

Hi again

I have another question for you guys. But, first of all, i would like to thank "moonfish" for helping me with my previous problem, cause of your help i am succesfully developing my gant tool.

Now to the topic.. I would like to color my cells in my gant tool, but not just color them but make them color diferently based on the letter specified in a cell.

So the cells are currently being colored by the value "1" in them.
What i would like is to add another condition.
So it would be:

• If the value of the cell (1st condition cell) is 1, then color it.
• If the value of the other cell (2nd condition cell) is letter "k", then color it GREEN
• If the value of the other cell (2nd condition cell) is letter "p", then color it YELLOW
• If the value of the other cell (2nd condition cell) is letter "n", then color it RED

So i guess u know what i wanna do, based on two diferent conditions, in two diferent cells, color cells with specified color.

I am adding the picture (the green cells have value 1 (=they should be colored), so how to make these cells red/yellow/green if the cell marked (not colored) contains letter "n"/"p"/"k" ). Thx for help guys.