Alignment for a cell during an if statement.
 

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?

Alignment for a cell during an if statement.
 

Use conditional formatting...
Choose one format for one result and another for another result

"kpt" wrote:

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?

Alignment for a cell during an if statement.
 

o.k. but how do I code that in the IF statement.

"Sheeloo" wrote:

Use conditional formatting...
Choose one format for one result and another for another result

"kpt" wrote:

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?

Alignment for a cell during an if statement.
 

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.

"kpt" wrote:

o.k. but how do I code that in the IF statement.

"Sheeloo" wrote:

Use conditional formatting...
Choose one format for one result and another for another result

"kpt" wrote:

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?

Alignment for a cell during an if statement.
 

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.
--
David Biddulph

Sheeloo wrote:
Use conditional formatting...
Choose one format for one result and another for another result

"kpt" wrote:

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?

Alignment for a cell during an if statement.
 

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

"Sheeloo" wrote:

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.

"kpt" wrote:

o.k. but how do I code that in the IF statement.

"Sheeloo" wrote:

Use conditional formatting...
Choose one format for one result and another for another result

"kpt" wrote:

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?

Alignment for a cell during an if statement.
 

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.

"kpt" wrote:

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

"Sheeloo" wrote:

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.

"kpt" wrote:

o.k. but how do I code that in the IF statement.

"Sheeloo" wrote:

Use conditional formatting...
Choose one format for one result and another for another result

"kpt" wrote:

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?

Alignment for a cell during an if statement.
 

I was wrong.

Excel 2007 does have an extra Number tab

"David Biddulph" wrote:

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.
--
David Biddulph

Sheeloo wrote:
Use conditional formatting...
Choose one format for one result and another for another result

"kpt" wrote:

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?