Hi, I wonder whether someone may be able to help me please.
I'm trying to put some code togther which searches column 'AE' on my spreadsheet starting at row 5 to row 2000. If the code finds the word 'Yes', I would like to clear any cell shading from columns B:Q on the same row if the Interior.ColorIndex = 35
I've started to put some code together, shown below, which clears all the cell formatting, but I'm not sure how to specify the colour to look for and then how to clear this interior colour:
[vba]If Target.Column = 31 Then
If Target.Value = "Yes" Then
Range("B" & Target.Row & ":Q" & Target.Row).ClearFormats
End If
End If[/vba]
I just wondered if someone could have a look at this please and offer a little guidance on how I may go about achieving this.
Sincere thanks and regards