Alignment for a cell during an if statement.

  • Thread starter Thread starter kpt
  • Start date Start date
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?
 
Use conditional formatting...
Choose one format for one result and another for another result
 
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.
 
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.
 
When you are in the conditional formatting menu, it does not allow you to
select cell alignment. Only font, border and color.
 
When you are in the conditional formatting menu, it does not allow you to
select cell alignment. Only font, border and color.
 
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.
 
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

Back
Top