Alignment for a cell during an if statement.

[kpt]

I want the alignment for a cell to be right justified for one result of the
if statement, but left justified for the other result. Any ideas?

 

[Sheeloo]

Don't change your IF statement

Suppose you have this in A1
=IF(B1=10,"B1 is 10","B1 is not 10")

Select A1
Choose Format->Conditional Formatting
Choose 'cell values is' 'equal to' B1 is 10
and choose formatting

add a condition and repeat for B1 is not 10.

_________________-
Click "Yes" if this helped.

 

[David Biddulph]

Are you sure that alignment can be used as a result of conditional
formatting, Sheeloo? Which version of Excel? I can't find any such ability
in Excel 2003.

 

[kpt]

When you are in the conditional formatting menu, it does not allow you to
select cell alignment. Only font, border and color.

 

[Sheeloo]

Sorry for wasting your time... I forgot about that.
Excel 2007 (which I normally use) has a NUMBER tab also where you can format
using CUSTOM formatting.

 

[Sheeloo]

I was wrong.

Excel 2007 does have an extra Number tab