Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weird prob: Format 3rd condition for other than first two | Excel Worksheet Functions | |||
use more than 3 condition in conditional format | Excel Worksheet Functions | |||
Condition Format | Excel Discussion (Misc queries) | |||
multiple condition lookup and match cell format | Excel Worksheet Functions | |||
Can I condition format, "if the cell contains a formula" | Excel Worksheet Functions |