EXCEL VBA: IF statement and using reference of other worksheets -

EXCEL VBA: IF statement and using reference of other worksheets -

i have 11 tabs of workbook multiple columns beingness used. worksheets 1200, 1400, 1530, 1600, 1630, 1700, 1730, 1800, 1830, 2000, , 2100. column need focus on column g. want macro scan column g of aforementioned worksheets dollar amounts duplicated, want duplicate dollar amounts alter colors. i'm having problem writing macro if has suggestions i'd appreciate greatly.

excel-vba