Hi I have a worksheet with two tabs (1 and 2). On tab 1 column A is
equal to whatever data pulls into Tab 2 column B. In Tab1 column A I
want the data to be formatted as follows:

Apple
Orange
Pineapple
Tangerine

Is there an easy formula for the justification for each cell? The
data that pulls in will change, which is why I cannot just use the
manual alignment to set all of the cells. Do I need to use
conditional formatting for this? And if so, how would I go about
doing that?

Thanks for your help.