View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] acampbell012@yahoo.com is offline
external usenet poster
 
Posts: 129
Default 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