For i = 1 To Cells(Rows.Count,"A").End(xlUp).Row
If Cells(i,"A").Value = "blue" And Cells(i,"B").Value = "Fred") Then
Cells(I,"A").Value = "red"
End If
Next i

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Stuart" wrote in message
...
Help - I want to update values in a column, but this is with conditions in
other cells e.g.
A B C
1 blue Fred
2 black Jim
3 blue Steve

change blue to red in column A, where content of B = Fred

Can this be done?