Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to color the background of a row if a certain
set of conditions exists. I don't know what's wrong with this: For i = rng.Row To 1 Step -1 If Cells(i, 9).Value = Cells(i - 1, 10).Value _ And Cells(i, 10).Value = Cells(i - 1, 9).Value _ And Cells(i, 1).Value = Cells(i - 1, 1).Value _ And Cells(i, 2).Value = Cells(i - 1, 2).Value _ Then Cells(i, 1).EntireRow.Interior.ColorIndex = 35 end if Next I've tried taking out the "end if", including just "end", but nothing works??? I get a 1004 error. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What is wrong with my UDF | Excel Discussion (Misc queries) | |||
What am I doing wrong? | Charts and Charting in Excel | |||
Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
What am I doing wrong? | New Users to Excel | |||
What am I doing wrong? | Excel Discussion (Misc queries) |