Hello All,
Totally new to excel macros and wondered if I could get some guidance.

I have a series of worksheets - one main and several that will be
populated from that sheet.

When certain records meet criteria, I use light yellow as a
highlighter for the background.....I need to be able to collect all
the highlighted records from sheet - 1st Assn to sheet - Failures.

I have the following macro recorded but it takes all the records not
the yellow ones (I set the format in Edit -Find-Options etc set the
color etc.


Application.FindFormat.Clear
With Application.FindFormat.Interior
.ColorIndex = 36
End With
Range("C13:D248").Select
Selection.Copy
Sheets("Failures").Select
Range("C13:D248").Select
ActiveSheet.Paste


I have searched the groups for similar solutions and tried without
success.

Any help would be appreciated.

John