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