Conditional format on data change

C

Carygee

I've a 5-column table with financial data sorted by the field "payee".
As the table is extensive I would like to highlight the row(preferably)
or the cell at each data change in the payee field.

Can this be done?
 
B

Bernard Liengme

I put some text in A10:A20 (a,a,a,b,c,c,c,........)
Selected A10:M20
Used Format | Conditional Formatting with ->
Formula is $A10<> $A9
opened the Pattern tab and selected a fill colour

Now the rows in range where text in A changes are coloured green
Note it colours the first row (we could do something about this if
important)

best wishes
 
Top