There are a few different ways that you can do this.
- Use Select Duplicate Rows
- Select the target column you want to see the change in
- Click on the red triangle located at the top of the Row Stat(Row Number) column, and select
- Row Selection=>Select Duplicate Rows
- All rows, except the first row for each new value of your target column will be selected. This may work perfectly for you,
but is you want only the first row for each group selected, and the none of the secondary rows selected, you can Invert the Row Selection
- Go back to the red triangle and select
- Row Selection=>Invert Row Selection
![txnelson_1-1697850631608.png txnelson_1-1697850631608.png](https://community.jmp.com/t5/image/serverpage/image-id/57870i3AA632F15EFC5C19/image-dimensions/233x289?v=v2)
2. You can use the Column Property to set the color values for each different value of the target column, and when you do that, you can specify to "Color the Cell by Value"
![txnelson_2-1697851033948.png txnelson_2-1697851033948.png](https://community.jmp.com/t5/image/serverpage/image-id/57871iF49BC258BE4A6E5D/image-size/medium?v=v2&px=400)
3. A simple script can color the cell where the value changes
Names Default To Here( 1 );
dt = Current Data Table();
For Each Row(
If( Row() == 1 | :Age != Lag( :age ),
dt:age << color cells( "green", Row() )
)
);
![txnelson_3-1697851347140.png txnelson_3-1697851347140.png](https://community.jmp.com/t5/image/serverpage/image-id/57872i384C19FD882B6D39/image-size/medium?v=v2&px=400)
I am sure there are other methods
Jim