问如何仅将单元格中的红色文本复制到另一个单元格中？

EN

Function TextByColor(Rng As Range, hex As String) As String
  Dim X As Long, S As String, clr As Long
  S = Rng.Text
  clr = HexToRGB(hex)
  For X = 1 To Len(Rng.Text)
    If Rng.Characters(X, 1).Font.Color <> clr Then
      If Mid(S, X, 1) <> vbLf Then Mid(S, X, 1) = " "
    End If
  Next
  RedText = Replace(Replace(Application.Trim(S), " " & vbLf, vbLf), vbLf & " ", vbLf)
End Function

Function HexToRGB(hex As String) As Long
    Dim r, g, b
    r = Application.Hex2Dec(Left(hex, 2))
    g = Application.Hex2Dec(Mid(hex, 3, 2))
    b = Application.Hex2Dec(Right(hex, 2))
    HexToRGB = RGB(r, g, b)
End Function

'Added: >10x faster alternative to using `Application.Hex2Dec`
Function HexToRGB2(hex As String) As Long
    Dim r As Long, g As Long, b As Long
    b = CLng("&H" & Right(hex, 2))
    g = CLng("&H" & Mid(hex, 3, 2))
    r = CLng("&H" & Left(hex, 2))
    HexToRGB2 = RGB(r, g, b)
End Function