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)



"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