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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Any help much appreciated, thanks
 
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)
 
Hi,

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

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

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

Andy Pope said:
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 said:
Without using VBA or conditional formatting, what is the syntax an "IF"
formula would take if i say, I wanted the contents of A1>5 to be shown in
green.

Any help much appreciated, thanks
Click to expand...
Click to expand...
 
You have replies at your other post.

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

Andy Pope said:
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 said:
Without using VBA or conditional formatting, what is the syntax an "IF"
formula would take if i say, I wanted the contents of A1>5 to be shown in
green.

Any help much appreciated, thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top