I have Excel 2003 : in this version you are limited to 3 conditional formattings,but i want to use 5 formats, so i run out of luck !

I want to use conditional format for the entire columm Q.

The text wich appears in the cells in column Q (Very Low, Low, Medium, High, Very high) is dependent of the Columns O & P.
The following formula is used :
=INDEX(Risikomatrix;VERGELIJKEN(O77;INDEX(Risikoma trix;0;1);0);VERGELIJKEN(P77;INDEX(Risikomatrix;1; 0);0))

So the cells in column Q can have the value : Very Low, Low, Medium, High, Very high (wich is the result of the values of the cells in col O & P)

When the text in the cell is "Very low" = the color of the cell has to be Green
When the text in the cell is "Low" = the color of the cell has to be Yellow
When the text in the cell is "Medium" = the color of the cell has to be Orange
When the text in the cell is "High" = the color of the cell has to be Light red
When the text in the cell is "Very High= the color of the cell has to be Dark red

Can someone help me with the VBA code.

Thanks,

Luc