conditional formatting

[jurasic]

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.

 

[Nothingman]

On the 2nd cell down create conditional formatting that says that if not equal to the above cell then bold the text. Make sure to remove the $ before the cell number. The just copy and paste special format to the cells below.

 

[JoeMo]

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.

Assuming the data starts in C1 and goes to C100 (change to fit your sheet), select C1 to C100 and use the conditional format:

=AND(C1="aspirin",COUNTIF(C$1:C1,"aspirin")=1)

Set the format to Bold when this condition is met.

 

[lenze]

Hi and welcome to the board!!
Select Column "C" then choose Format>Conditional Formatting
Select the "Formula Is" option
Now enter this

=COUNTIF($C$1:$C1,$C1)=1

Format as desired. I would use a color, but you can use Bold if that's what you require

lenze
BTW: Nothingham's suggestion will also work quite well

 

[jurasic]

All solutions are working for me. I needed Nothingman's reminder to remove the $ from the row.

You are all awesome. Thank you for the quick responses. What a great board.