Macro to convert value in Col E to a negative value where text "Balance"' is in Col A

I have data that is imported


where Col A contains text "Balance" , the the value in the same row as Balance must be converted to a negative number


It would be appreciated if someone could provide me with the code to do this