I've used conditional formatting in excel to find highlight repeat customers in one column. I'd like to indicate in another column "Yes" showing they are now eligible for a discount but I cannot seem to produce the result off the conditional formatting. Is it even possible and if so, how? Thank you!