How do I use "IF" statments to colour text?
 

Without using VBA or conditional formatting, what is the syntax an "IF"
formula would take if i say, I wanted the contents of A15 to be shown in
green.

Any help much appreciated, thanks

How do I use "IF" statments to colour text?
 

Not possible if you are eliminating the use of VB or conditional formatting.



Mike

"Ashhy Larry" wrote:

Without using VBA or conditional formatting, what is the syntax an "IF"
formula would take if i say, I wanted the contents of A15 to be shown in
green.

Any help much appreciated, thanks

How do I use "IF" statments to colour text?
 

Try conditional formatting.

See http://www.contextures.com/xlCondFormat01.html

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Mike H" wrote in message
...
Not possible if you are eliminating the use of VB or conditional
formatting.



Mike

"Ashhy Larry" wrote:

Without using VBA or conditional formatting, what is the syntax an "IF"
formula would take if i say, I wanted the contents of A15 to be shown in
green.

Any help much appreciated, thanks

How do I use "IF" statments to colour text?
 

oops just noticed that you discounted CF. Why?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Mike H" wrote in message
...
Not possible if you are eliminating the use of VB or conditional
formatting.



Mike

"Ashhy Larry" wrote:

Without using VBA or conditional formatting, what is the syntax an "IF"
formula would take if i say, I wanted the contents of A15 to be shown in
green.

Any help much appreciated, thanks

How do I use "IF" statments to colour text?
 

Hi,

A custom number format
[Green][5]General;General

Although as the others have said, why no use of conditional format?

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Ashhy Larry" <Ashhy wrote in message
...
Without using VBA or conditional formatting, what is the syntax an "IF"
formula would take if i say, I wanted the contents of A15 to be shown in
green.

Any help much appreciated, thanks

How do I use "IF" statments to colour text?
 

I have the same problem. conditional format limits to three different
formats. i need 10.

"Andy Pope" wrote:

Hi,

A custom number format
[Green][5]General;General

Although as the others have said, why no use of conditional format?

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Ashhy Larry" <Ashhy wrote in message
...
Without using VBA or conditional formatting, what is the syntax an "IF"
formula would take if i say, I wanted the contents of A15 to be shown in
green.

Any help much appreciated, thanks

How do I use "IF" statments to colour text?
 

You have replies at your other post.

Mats K wrote:

I have the same problem. conditional format limits to three different
formats. i need 10.

"Andy Pope" wrote:

Hi,

A custom number format
[Green][5]General;General

Although as the others have said, why no use of conditional format?

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Ashhy Larry" <Ashhy wrote in message
...
Without using VBA or conditional formatting, what is the syntax an "IF"
formula would take if i say, I wanted the contents of A15 to be shown in
green.

Any help much appreciated, thanks


--

Dave Peterson

How do I use "IF" statments to colour text?
 

See http://www.contextures.com/xlCondFormat01.html

Sweet! Thanks.

"Bob Phillips" wrote:

Try conditional formatting.

See http://www.contextures.com/xlCondFormat01.html

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Mike H" wrote in message
...
Not possible if you are eliminating the use of VB or conditional
formatting.



Mike

"Ashhy Larry" wrote:

Without using VBA or conditional formatting, what is the syntax an "IF"
formula would take if i say, I wanted the contents of A15 to be shown in
green.

Any help much appreciated, thanks