| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Based on if the contents of a cell have a certain format
Ok, So I'm taking the advice and just doing a copy paste per line.
What I'm working on now is trying to figure out how to make the decision wether to copy or not based on the fact that the cell contents are in Black Bold Text. Can anyone help? TIA E |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying Based on if the contents of a cell have a certain format
This should do. Just modify to fit your range conditions
With Selection If Selection.Font.Bold = True And _ Selection.Font.ColorIndex = 1 Then MsgBox "Conditions met" End If End With End Sub Egon wrote: Ok, So I'm taking the advice and just doing a copy paste per line. What I'm working on now is trying to figure out how to make the decision wether to copy or not based on the fact that the cell contents are in Black Bold Text. Can anyone help? TIA E |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format based on cell contents being a formula or not | Excel Worksheet Functions | |||
| Can I format a row based on the contents of one cell? | Excel Discussion (Misc queries) | |||
| Set number format based on cell contents | Excel Discussion (Misc queries) | |||
| Copying color format of cell contents | Excel Discussion (Misc queries) | |||
| Copying format to a new cell, w/o overwriting destination cell contents | Excel Discussion (Misc queries) | |||
Linear Mode
