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.