Forum Discussion
Solved
Conditional Format w/ Text Exception
Having a tough time figuring this one out. I have a list of reports in a sheet. One column is full of report numbers. I want to conditionally format, highlight any duplicate report number, EXCEP...
You may try this...
Select the whole column C and make a New Rule for conditional formatting using the formula given below and set the format as per your choice.
=AND(COUNTIF(C:C,C1)>1,C1<>"DRAFT")
Thanks for the explanation!
No problem!