Alignment for a cell during an if statement.

K

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?
 
S

Sheeloo

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

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.
 
S

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.
 
K

kpt

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

kpt

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

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.
 
S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

by default text is left justified, numbers are right justified - a specific reason for this? 2
merge cells without losing data OR format 1
protect cell format 1
Undeletable mark--amazing properties 3
Elliminating gaps between adjacent cells 3
Centering text in right-side header block 2
HIDDEN FEATURE?? Paragraph - not Justified, Distributed! 9
Text Alignment 2

Top