Is there a way to set up conditional formatting so that is the text in the
row above is the same as the the current row,
that the text could change color?

So in a column you have rows like

aaa
bbb
ccc
ccc

the 4th row could be colored different. Because the row above is the same
text.

thanks