Excel and Conditional formatting

[Calibutterfly]

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.

 

[FSt1]

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