Add fromula to data validation

Hi ,

So you want the product 4 in sheet 1 to be converted in to uppercase the moment you have entered in sheet 1

Punnam

Well not just "product 4", i picked any random product from sheet2. But yes, i would like any data that is entered in that cell to automatically be converted to uppercase.