Assuming the data starts in C1 and goes to C100 (change to fit your sheet), select C1 to C100 and use the conditional format:I need to bold the text whenever the text in column C changes. So column C has many rows C that contain "alligator". When that changes to "aspirin" the first occurance should be bold.
I'm not sure how to approach this.
Thanks in advance.
=AND(C1="aspirin",COUNTIF(C$1:C1,"aspirin")=1)
=COUNTIF($C$1:$C1,$C1)=1