Range highlighting is not enough? Well, how about autocomplete for function name:
It was quite easy because I just need to adapt the fancy completion code that I have already. I still need to polish this (and check for bugs) before committing to SVN. Likely however that it will make it into next KOffice 1.5.
And, seems that Microsoft Office people are doing the same :-P