Select all except the first cell in the column (starting with the second
cell so that it is the active cell) and use this formula in the Conditional
Formatting dialog box (Formula Is option)...

=A2=A1

where I have assumed A2 is the active cell in the selected cells.

--
Rick (MVP - Excel)


"greg" wrote in message
...
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