Formula to Colour a cell if criteria meet

Hi

I work in a company where macros are not allowed and we are using Excel 2003.

I am finding a formula where I can colour a particular cell if it passes criteria.

Problem is I have 10 different colours.

Conditional formatting has limitation of 3 colours.

I will explain my problem as follows-
Column A has different asset codes.
If Asset Code = A then give colour red
If Asset Code = B then give colour yellow
If Asset Code = C then give colour blue
If Asset Code = D then give colour black
etc

How to this using some formula, as I cannot use VB, macros and conditional formatting.

Please help

In your profile, you have Excel 2007!

Salut,
with conditional formatting, you should use Rule type: "Use a formula to determine which cells to format".
you can colour cell with more different conditions...
See attached file

Hi duanzhuanming,

Thanks a lot for your reply. But we are using Excel 2003 in which there is limit of 3 conditions.

Hence, I was looking for some formula.

Can you please help me how to do same in Excel 2003.

Hi caavimak

Thanks for changing your profile. I found this thread, perhaps it my help.

http://www.excelforum.com/excel-gene...n-3-rules.html

Hi Kevin

Thanks a lot for your reply.

Problem is that I cant use macros in my company. They don't allow for security reasons.

Can I get some formula in Excel 2003.