We run a macro that selects duplicates and formats with background with a
color. We need to include that cell formatting in an IF statement. Can it be
done and, if so, what would be the syntax?