|
如果E2<0,且F2包含“失效“,则C2标记为红色,以下代码运行时,提示是子程序或函数未定义,应该如何修改呢?
(暂定有146行)
Sub hightlight()
For r = 1 To 146
If Cells(5, r) < 0 And InStr(1, Cells(6, r).Value, "失效", vbTextCompare) = 0 Then cell(3, r).Interior.Color = vbRed
Next
End Sub
- Sub hightlight()
- For r = 1 To 146
- If Cells(r, 5) < 0 And InStr(1, Cells(r, 6).Value, "失效", vbTextCompare) > 0 Then Cells(r, 3).Interior.Color = vbRed
- Next
- End Sub
复制代码
|
|