本帖最后由 冥王 于 2015-5-26 21:29 编辑
再不行就传一个附件吧- Sub demoRGB()
- On Error Resume Next
- Dim r As Range, arr, i%
- i = Cells(Rows.Count, "C").End(xlUp).Row
- For Each r In Range("C3:C" & i)
- arr = Split(r, ",")
- r.Offset(0, 2).Interior.Color = RGB(CInt(arr(0)), CInt(arr(1)), CInt(arr(2)))
- r.Offset(0, 2).Font.Color = RGB(255 - CInt(arr(0)), 255 - CInt(arr(1)), 255 - CInt(arr(2)))
- Next
- End Sub
复制代码 |