Thanks a lot for the information and website Gary.

"Gary''s Student" wrote:

Conditional formatting might be used if we can figure out how to detect if
the row above the row being formatted is bold or not.

If would be easy if all the "A" are bold, all the "B" are not, all the "C"
are bold.

In your case, if there are only "A" and "C", you want the "C" to be not bold.


Macros are very easy to install and use:

1. ALT-F11 brings up the VBE window
2. ALT-I
ALT-M opens a fresh module
3. paste the stuff in and close the VBE window

If you save the workbook, the macro will be saved with it.

To remove the macro:

1. bring up the VBE window as above
2. clear the code out
3. close the VBE window

To use the macro from Excel:

1. ALT-F8
2. Select the macro
3. Touch RUN

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

and we can adjust the code to work with any column and any starting cell!
--
Gary''s Student - gsnu200835


"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.