| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Cell alignment, how do I update the default vertical alignment | Setting up and Configuration of Excel | |||
| cell alignment | Excel Discussion (Misc queries) | |||
| Excel cell alignment | Excel Worksheet Functions | |||
| How do you set the cell vertical alignment to bottom? | Excel Discussion (Misc queries) | |||
| Default cell alignment | Excel Discussion (Misc queries) | |||
Linear Mode
