Hi, is there a way to do a conditional formatting for data to be always in upper case?

I have a long list of names in a few columns that I need to copy and paste every week but I want them to paste in UPPER case every time. I know you can do it with formulas but I heard that there was a way that the conditional formatting can do it for me. is this true?