View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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