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.

CF can handle complex multiple conditions, it can only handle 3 separate
cases per cell unless you have Excel 2007.

--
__________________________________
HTH

Bob

"Nysh" <(E-Mail Removed)> wrote in message
news:db215007-739b-4c89-a053-(E-Mail Removed)...
>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.

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" <Bob...@somewhere.com> wrote:
> CF can handle complex multiple conditions, it can only handle 3 separate
> cases per cell unless you have Excel 2007.
>
> --
> __________________________________
> HTH
>
> Bob
>
> "Nysh" <nishan...@gmail.com> wrote in message
>
> news:db215007-739b-4c89-a053-(E-Mail Removed)...
>
>
>
> >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 -

That is a custom format (Cells>Format>Custom ). You could add that to give a
couple more.

--
__________________________________
HTH

Bob

"Nysh" <(E-Mail Removed)> wrote in message
news:465b6a02-575c-4729-9b0a-(E-Mail Removed)...
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" <Bob...@somewhere.com> wrote:
> CF can handle complex multiple conditions, it can only handle 3 separate
> cases per cell unless you have Excel 2007.
>
> --
> __________________________________
> HTH
>
> Bob
>
> "Nysh" <nishan...@gmail.com> wrote in message
>
> news:db215007-739b-4c89-a053-(E-Mail Removed)...
>
>
>
> >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 -

Can we put some conditions in this too?

Plz reply...



On Nov 16, 8:07*pm, "Bob Phillips" <Bob...@somewhere.com> wrote:
> That is a custom format (Cells>Format>Custom ). You could add that to give a
> couple more.
>
> --
> __________________________________
> HTH
>
> Bob
>
> "Nysh" <nishan...@gmail.com> wrote in message
>
> news:465b6a02-575c-4729-9b0a-(E-Mail Removed)...
> 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" <Bob...@somewhere.com> wrote:
>
>
>
> > CF can handle complex multiple conditions, it can only handle 3 separate
> > cases per cell unless you have Excel 2007.
>
> > --
> > __________________________________
> > HTH
>
> > Bob
>
> > "Nysh" <nishan...@gmail.com> wrote in message
>
> >news:db215007-739b-4c89-a053-(E-Mail Removed)....
>
> > >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 -

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

--
__________________________________
HTH

Bob

"Nysh" <(E-Mail Removed)> wrote in message
news:1053e348-17c5-4687-b9e4-(E-Mail Removed)...
Can we put some conditions in this too?

Plz reply...



On Nov 16, 8:07 pm, "Bob Phillips" <Bob...@somewhere.com> wrote:
> That is a custom format (Cells>Format>Custom ). You could add that to give
> a
> couple more.
>
> --
> __________________________________
> HTH
>
> Bob
>
> "Nysh" <nishan...@gmail.com> wrote in message
>
> news:465b6a02-575c-4729-9b0a-(E-Mail Removed)...
> 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" <Bob...@somewhere.com> wrote:
>
>
>
> > CF can handle complex multiple conditions, it can only handle 3 separate
> > cases per cell unless you have Excel 2007.
>
> > --
> > __________________________________
> > HTH
>
> > Bob
>
> > "Nysh" <nishan...@gmail.com> wrote in message
>
> >news:db215007-739b-4c89-a053-(E-Mail Removed)...
>
> > >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 -