IF, Then VBA w/Conditional Formatting Question

[rrrepp]

Hi I'm really having trouble with this VBA. I'm average at best at using Visual Basic, but i've got a general understanding. I'm trying to look at two columns that have the answer 'yes' or 'no' in them (Column N & Column O) and depending on it being a yes i'd like to highlight a cell offset. If yes in Column N, then highlight cell in E. If yes in Column O, then highlight cell in K. Here is the code i've been writing but i keep getting errors at every turn. Thanks for the help.

Sub ConditionalFormat()

Dim ColN As Range
Dim ColO As Range

Set ColN = ActiveSheet.Range("N54:N425")
Set ColO = ActiveSheet.Range("O54:O425")
If ColN = Yes Then
Cell.Offset(0, -9).Interior.ColorIndex = 27
ElseIf ColO = Yes Then
Cell.Offset(0, -4).Interior.ColorIndex = 27
Else
End If
End Sub

 

[HalfAce]

Most welcome. Glad it helped.