excel, upper case

I am building a spread sheet and I want all text entered into a paticular cell to be upper case all other cells will be lower case. I know you can turn on caps but I dont to have to turn it on and off. I want the spread sheet to do it by itself. Can anyone tell me how to do this.

thanx

 

Conditional formatting ?
If Cell not empty, then Font = ......
regards

 

I dont see where it says you can use upper case for a format. Could you tell me how to do this.

thanx

 

Check out this thread on The Office Experts forum.

 

What I had in mind was that you look for a caps-only font in the style you want and use that with conditional formatting.
Also, as far as I remember, when you install a font you can choose
"capital letters only "
regards