That is a custom format (CellsFormatCustom ). You could add that to give a
couple more.

--
__________________________________
HTH

Bob

"Nysh" wrote in message
...
Isn't there any other way?

I had a look on help and found some code like "[red][100];" but didnt
get... how to implement it?


On Nov 13, 1:35 pm, "Bob Phillips" wrote:
CF can handle complex multiple conditions, it can only handle 3 separate
cases per cell unless you have Excel 2007.

--
__________________________________
HTH

Bob

"Nysh" wrote in message

...



I want to change the textcolorof a cell.

The conditional formatting is not what I really seeking for because I
have some complex multiple conditions.

Help me outifyou friends have any solution for me.- Hide quoted text -

- Show quoted text -