is there anyway to reference a cell based on conditional formatting ? for example, A1 is John, B1 is Fish, C99 is John. I perform conditional formatting on column A and column C, and once John is found to be a duplicate in A1, I want to delete the adjacent cell, which is Fish in B1. How can this done with VBA coding? THanks.