ExcelBanter - View Single Post - How do I use "IF" statments to colour text?

Lori

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