Results 1 to 3 of 3
Thread: Excel -
Hybrid View
-
14th December 2013 16:33 #1Registered User
Join Date: Mar:2008
Location: BG
Posts: 162
Excel -
Excel 2003. . .
? - Range("E8:AM175") < 0Code:Dim cell As Range For Each cell in Range("E8:AM175") If cell.Interior.ColorIndex < 0 Then ' ( ) < 0 cell.Interior.ColorIndex = 3 End If Next cell End Sub
-
15th December 2013 22:33 #2
workbook E8:AM175 .
- 1, .
E8:AM175 , .
, , workbook?
, , .
-
16th December 2013 15:47 #3Registered User
Join Date: Mar:2008
Location: BG
Posts: 162
' cell.Interior.ColorIndex = 3
If cell.Interior.ColorIndex < 0 Then .
workbook Book1 - E8:AM175 < 0 xlNone. workbook Book2 Book1.




Reply With Quote
7th May 2023, 16:02 in PC