Cell format as condition
 

I would like to evaluate the formatting of a cell as a condition to setting
the value in another cell. For example, I have list values in cell in which
the user has used BOLD format to indicate choice. I would like to read the
identify the cells with BOLD format and they populate value of the cell in
new cell. Any suggestions or help is greatly appreciated. Thanks in advance.

- mars

Cell format as condition
 

Not sure if it was what you are after:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Font.Bold = True Then
ActiveCell.Offset(1, 0).Value = ActiveCell.Value
End If
End Sub

Modify the offset to suit.

Corey....

"mars" wrote in message
...
I would like to evaluate the formatting of a cell as a condition to setting
the value in another cell. For example, I have list values in cell in
which
the user has used BOLD format to indicate choice. I would like to read
the
identify the cells with BOLD format and they populate value of the cell in
new cell. Any suggestions or help is greatly appreciated. Thanks in
advance.

- mars