Help needed in Excel

I have a cell that changes their values when I enter a text in another cell. This are validations.   Cell L46 = Error - Please provide an explanation  Cell E46 is blank   Then when I write an Ex...