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