More than 3 conditional formating per cell

Dear all

I have a large X-Y-axis table with about 200 entries in it. There are 6 different entries possible. I now want to give each possible entry in this table a color for making it easier to read.

I could write a formula in conditional formating, so that it works for 3 colors. The problem is now that i can make this only for 3 different colors in conditional formating of excel. Is there a possibility for making this for 6 colors?

I know that this could be done with a simple Macro, but i cant use macros for this file...

I hope you can help me!!!

Thanks in advance

Spence

If running a pre Excel 2007 version you are limited to 3 colours. The only way to go beyond 3 colours is to use VBA which you say you can't use so I'm afraid you are stuck.