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.

hi
this type of formating is not available through conditional fomating.
fonts, font style, font weight and color
border, border style and colorcolor
background color, patterns
that's it.
I know of no formula that will do this. maybe a UDF.

sorry.
regards
FSt1

"Calibutterfly" wrote:

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.