第1个回答 2012-10-18
1. 编辑/寻找/格式/选择字体颜色为红色
2. 全部寻找/ 下面会出来区域
3. 全选所出来的区域(寻找到的)
-------
然后,复制 ,粘贴!
---------------
你可以录制宏
以下是我录 的
With Application.FindFormat.Font
.Subscript = False
.ColorIndex = 3
End With
Selection.Copy
Sheets("Sheet2").Select
ActiveSheet.Paste
Application.WindowState = xlMinimized
Application.WindowState = xlNormal
-------------------
以上,我是设的,当为红色时,选取后复制本回答被网友采纳
第2个回答 推荐于2016-08-20
制作一个VB程序来解决:
Sub tqhs()
Dim Myr%, x%, n%, aa, y%, col%, Myc%
Application.ScreenUpdating = False
Myr = [a65536].End(xlUp).Row
For x = 1 To Myr
col = 2
aa = Len(Cells(x, 1))
For y = 1 To aa
If Cells(x, 1).Characters(y, 1).Font.ColorIndex = 3 Then
n = 1
Cells(x, col) = Cells(x, col) & Cells(x, 1).Characters(y, 1).Text
ElseIf n = 1 Then
col = col + 1: n = 0
End If
Next y
Next x
Myc = [a1].CurrentRegion.Columns.Count
Range(Cells(1, 2), Cells(Myr, Myc)).Font.ColorIndex = 3
Application.ScreenUpdating = True
End Sub