Copying Based on if the contents of a cell have a certain format

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing contents of cell based on Cell Format	HeatherJ	Microsoft Excel Worksheet Functions	3	22nd Dec 2009 03:06 PM
How do I format one cell based on contents in another cell in Exce	=?Utf-8?B?amFuZXQ2ODY=?=	Microsoft Excel Misc	2	13th Apr 2007 06:20 PM
Can I format a row based on the contents of one cell?	=?Utf-8?B?S2lyc3R5?=	Microsoft Excel Misc	1	23rd May 2006 02:57 PM
Copying color format of cell contents	=?Utf-8?B?S2VpdGggQnJvd24=?=	Microsoft Excel Misc	2	18th Oct 2005 08:26 PM
Copying format to a new cell, w/o overwriting destination cell contents	James C	Microsoft Excel Misc	1	18th Oct 2005 08:02 PM