Cell Color condition using IF... ELSE statement in Excel
 

I want to change the text color of a cell.

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

Help me out if you friends have any solution for me.

Cell Color condition using IF... ELSE statement in Excel
 

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 text color of a cell.

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

Help me out if you friends have any solution for me.

Cell Color condition using IF... ELSE statement in Excel
 

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 -

Cell Color condition using IF... ELSE statement in Excel
 

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 -

Cell Color condition using IF... ELSE statement in Excel
 

Can we put some conditions in this too?

Plz reply...



On Nov 16, 8:07*pm, "Bob Phillips" wrote:
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 -- Hide quoted text -

- Show quoted text -

Cell Color condition using IF... ELSE statement in Excel
 

Only simple ones such as a number < 1000 as an example.

--
__________________________________
HTH

Bob

"Nysh" wrote in message
...
Can we put some conditions in this too?

Plz reply...



On Nov 16, 8:07 pm, "Bob Phillips" wrote:
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 -- Hide quoted text -

- Show quoted text -