If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
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? |
#7
|
|||
|
|||
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? |
#8
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|