how do i solve the for without next error i keep getting

[pveke]

Dim aRng, bRng As Range
Set aRng = Range("AC5:A175")
Set bRng = Range("AD5:AD175")

For Each aCell In aRng
    For Each bcell In bRng
    If aCell Like "true" And bcell Like "false" Then
         bcell.Interior.ColourIndex = 3
           Else: bcell.Interior.ColourIndex = 10
    End If
Next
For Each cCell In aRng
    For Each dcell In bRng
    If cCell = "yes" And dcell = "no" Then
           dcell.Interior.ColourIndex = 3
            Else: dcell.Interior.ColourIndex = 10
    End If
Next
For Each eCell In aRng
    For Each fcell In bRng
    If eCell Like "good" And fcell Like "bad" Then
           fcell.Interior.ColourIndex = 10
            Else: fcell.Interior.ColourIndex = 3
    End If
Next
For Each gCell In aRng
    For Each hcell In bRng
    If gCell Like "N/A" Then
           hcell.Interior.ColourIndex = 10
    End If
Next
For Each iCell In aRng
    For Each jcell In bRng
    If jcell Like "sucks" Then
           jcell.Interior.ColourIndex = 3
    End If

Next
End Sub

 

[Fluff]

You need another next after each End If line

 

[pveke]

thanks

 

[Fluff]

You have other problems with the code ColourIndex = should be ColorIndex =
Also I'm not sure the code is going to do what you want.
Can you please explain what you are trying to do?

 

[pveke]

I am trying to compare two columns such that if column A is Escalation Standby and Column B is Absent then column B should be formatted to a colour red otherwise green

 

[Fluff]

You can do that using conditional formatting like

+Fluff New.xlsm
	A	B
1
2	Escalation Standby	in
3	Escalation	absent
4	Standby	absent
5	Escalation Standby	absent
6	something	holiday
7	Escalation Standby	holiday
8
9
10
11
Master

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:B100	Expression	=AND(A2="escalation standby",B2="Absent")	text	NO
B2:B100	Expression	=B2<>""	text	NO

 

[pveke]

what I specifically want to do is combine the five conditions below into one
1. if column A is Escalation Standby and Column B is Absent then column B should be formatted to a colour red otherwise green
2. if column A is Standby and Column B is Absent then column B should be formatted to a colour red otherwise green
3. if column A is attended and Column B is Attended then column B should be formatted to a colour green otherwise red
4, if column A is NA and Column B is Absent then column B should be formatted to colour green otherwise red
5, if column B is absent then column B should be formatted to a red colour

 

[Fluff]

Point 5 is in conflict with point 4 & renders points 1 & 2 irrelevant.

 

[pveke]

let me have a look at that

 

[pveke]

the conditions are listed below:
1. If column A = Escalation Standby and column B=Absent", then background color for column B should be red and if the value is other than "Absent" then the background color is green.

2. If column A = Attend and column B=Absent then the background color for column B should be green, and if the value is NOT "Attend" then the background color is red.