I am having trouble formatting duplicate values across two sheets with my macro. The values that I am trying to check for duplicates are both in column A. I know how to write the VBA for duplicate conditional formatting just not across two sheets. Please help!