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