| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alphabetically list of last names: BOLD, not bold
Lerner
I have tested the result using the names in this thread and the result is the same as using the macro provided by Gary Did you place the 1st formula in B2 and copy down? if you have place this formula in some other column, you need to adjust the formula to that column. and when applying the CF, did you select all the cells, ie from A1 to A100 or wherever it end, before you place the 2nd formula in CF. .. -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis "Lerner" wrote: Thanks, Francis, however using the 'dummy column' did not give me the results expected as it just BOLDED the first item in the row(unless something wrong was done by me). I have some macros in some workbooks, but the especific problem is that all of those workbooks with macros take an eternity to save the workbook everytime. "francis" wrote: Lerner Conditional Formatting can do it but indirectly. I have provided you a solution in your old post without a macro as you have mentioned that you don't want to use macro if possible otherwise the macro provided by Sheeloo may have done the job. -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis "Lerner" wrote: Thanks Gary, for going with the extra effort and detailed explanation in order to help me, I really appreciate your time. Not meaning to be a pain, but this means Conditional Formatting won't be able to do it ? Thank you again. "Gary''s Student" wrote: This assumes that the names are stored in column A starting with A1. Enter run run the following macro: Sub boldAlternator() Dim n As Long, FlipFlop As Boolean n = Cells(Rows.Count, 1).End(xlUp).Row Cells(1, 1).Font.Bold = True FlipFlop = True For i = 2 To n If Left(Cells(i, 1).Value, 1) = Left(Cells(i - 1, 1).Value, 1) Then Else FlipFlop = Not FlipFlop End If Cells(i, 1).Font.Bold = FlipFlop Next End Sub Suppose we start with data like: Adams, Raymond Allen, Timothy Anderson, Christopher Baker, Gregory Brown, William Campbell, Henry Carter, Dennis Clark, Ronald Collins, Roger Davis, David Edwards, Ryan Evans, Arthur Garcia, Steven Gonzalez, Joshua Green, Andrew Hall, Gary Harris, Donald Hernandez, Larry Hill, Eric Jackson, Paul Johnson, John Jones, Michael King, Jeffrey Lee, Jason Lewis, Kevin Lopez, Scott Martin, George Martinez, Edward Miller, Richard Mitchell, Walter Moore, Joseph Nelson, Jerry Parker, Carl Perez, Patrick Phillips, Douglas Roberts, Peter Robinson, Brian Rodriguez, Anthony Scott, Stephen Smith, James Taylor, Thomas Thomas, Daniel Thompson, Kenneth Turner, Harold Walker, Matthew White, Mark Williams, Robert Wilson, Charles Wright, Frank Young, Jose The following name will be Bold, the other not: Adams, Raymond Allen, Timothy Anderson, Christopher Campbell, Henry Carter, Dennis Clark, Ronald Collins, Roger Edwards, Ryan Evans, Arthur Hall, Gary Harris, Donald Hernandez, Larry Hill, Eric King, Jeffrey Martin, George Martinez, Edward Miller, Richard Mitchell, Walter Moore, Joseph Parker, Carl Perez, Patrick Phillips, Douglas Scott, Stephen Smith, James Walker, Matthew White, Mark Williams, Robert Wilson, Charles Wright, Frank -- Gary''s Student - gsnu200835 "Lerner" wrote: All items beggining with A BOLD Last name and Fist name BOLD (full name)as they are in the same cell. THANKS Gary. "Gary''s Student" wrote: Do you want all of the items beginning with "A" to be bold or only the first item? Do you want only the lastname to be bold or the fullname? -- Gary''s Student - gsnu200835 "Lerner" wrote: Actually none of them had work. A B C 1 NAMES 2 ARIES, JOHN 3 ACTUAL, JANE 4 CONSECUTIVE, MIKE 5 EXCEL, MICROSOFT 6 EVEREST, TRISIA 7 HINGS, PAULA Basically the thing is get the first one ( last name with A) BOLD and then alternating with the list (not bold, bold, not bold, bold) regardless of the missing secuency as in this case it will be ABOLD, Cnot bold, E bold, H not bold. I'd rather use conditional formatting than MACROS. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Alphabetically list of last names: BOLD, not bold
It did not work because a simple detail:
You wrote in FORMULA IS: =B1=O (Incorrect) I started changing in around and the correct one is: FORMULA IS: =B2=O (right one) Probably that's what you did when it worked but by mistake or typo you posted =B1=0 (Incorrect). However the human error, VERY CLEAVER interesting formula, got it handed to you, well deserved congratulations. However(never ends) if you read my posts carefully The BOLD should start the secuency and I get NOT BOLD first, I'm sure there is an adjustment I can find as a homework as I don't want to bother anymore. Thanks again francis. "francis" wrote: Lerner I have tested the result using the names in this thread and the result is the same as using the macro provided by Gary Did you place the 1st formula in B2 and copy down? if you have place this formula in some other column, you need to adjust the formula to that column. and when applying the CF, did you select all the cells, ie from A1 to A100 or wherever it end, before you place the 2nd formula in CF. . -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis "Lerner" wrote: Thanks, Francis, however using the 'dummy column' did not give me the results expected as it just BOLDED the first item in the row(unless something wrong was done by me). I have some macros in some workbooks, but the especific problem is that all of those workbooks with macros take an eternity to save the workbook everytime. "francis" wrote: Lerner Conditional Formatting can do it but indirectly. I have provided you a solution in your old post without a macro as you have mentioned that you don't want to use macro if possible otherwise the macro provided by Sheeloo may have done the job. -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis "Lerner" wrote: Thanks Gary, for going with the extra effort and detailed explanation in order to help me, I really appreciate your time. Not meaning to be a pain, but this means Conditional Formatting won't be able to do it ? Thank you again. "Gary''s Student" wrote: This assumes that the names are stored in column A starting with A1. Enter run run the following macro: Sub boldAlternator() Dim n As Long, FlipFlop As Boolean n = Cells(Rows.Count, 1).End(xlUp).Row Cells(1, 1).Font.Bold = True FlipFlop = True For i = 2 To n If Left(Cells(i, 1).Value, 1) = Left(Cells(i - 1, 1).Value, 1) Then Else FlipFlop = Not FlipFlop End If Cells(i, 1).Font.Bold = FlipFlop Next End Sub Suppose we start with data like: Adams, Raymond Allen, Timothy Anderson, Christopher Baker, Gregory Brown, William Campbell, Henry Carter, Dennis Clark, Ronald Collins, Roger Davis, David Edwards, Ryan Evans, Arthur Garcia, Steven Gonzalez, Joshua Green, Andrew Hall, Gary Harris, Donald Hernandez, Larry Hill, Eric Jackson, Paul Johnson, John Jones, Michael King, Jeffrey Lee, Jason Lewis, Kevin Lopez, Scott Martin, George Martinez, Edward Miller, Richard Mitchell, Walter Moore, Joseph Nelson, Jerry Parker, Carl Perez, Patrick Phillips, Douglas Roberts, Peter Robinson, Brian Rodriguez, Anthony Scott, Stephen Smith, James Taylor, Thomas Thomas, Daniel Thompson, Kenneth Turner, Harold Walker, Matthew White, Mark Williams, Robert Wilson, Charles Wright, Frank Young, Jose The following name will be Bold, the other not: Adams, Raymond Allen, Timothy Anderson, Christopher Campbell, Henry Carter, Dennis Clark, Ronald Collins, Roger Edwards, Ryan Evans, Arthur Hall, Gary Harris, Donald Hernandez, Larry Hill, Eric King, Jeffrey Martin, George Martinez, Edward Miller, Richard Mitchell, Walter Moore, Joseph Parker, Carl Perez, Patrick Phillips, Douglas Scott, Stephen Smith, James Walker, Matthew White, Mark Williams, Robert Wilson, Charles Wright, Frank -- Gary''s Student - gsnu200835 "Lerner" wrote: All items beggining with A BOLD Last name and Fist name BOLD (full name)as they are in the same cell. THANKS Gary. "Gary''s Student" wrote: Do you want all of the items beginning with "A" to be bold or only the first item? Do you want only the lastname to be bold or the fullname? -- Gary''s Student - gsnu200835 "Lerner" wrote: Actually none of them had work. A B C 1 NAMES 2 ARIES, JOHN 3 ACTUAL, JANE 4 CONSECUTIVE, MIKE 5 EXCEL, MICROSOFT 6 EVEREST, TRISIA 7 HINGS, PAULA Basically the thing is get the first one ( last name with A) BOLD and then alternating with the list (not bold, bold, not bold, bold) regardless of the missing secuency as in this case it will be ABOLD, Cnot bold, E bold, H not bold. I'd rather use conditional formatting than MACROS. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alphabetically list of names BOLD and NOT bold | Excel Discussion (Misc queries) | |||
| Bold Row if Col E is bold | Excel Discussion (Misc queries) | |||
| Bold | Excel Worksheet Functions | |||
| Join bold and non-bold text in one cell | Excel Discussion (Misc queries) | |||
| How do you sum just values that are bold in a list of values? | Excel Worksheet Functions | |||
Hybrid Mode
