topic How to highlight cell if previous row is different (kinda conditional formatting in Excel) in Discussions

How to highlight cell if previous row is different (kinda conditional formatting in Excel)

miguello — Fri, 20 Oct 2023 23:50:27 GMT

Running a DOE experiment for the first time.

Afraid to misread a value for a factor - tens of factors, tens of runs. Any way for a specific row to highlight a cell if its value is different from cell value in a previous row? So that I don't miss a value that changed in the next experiment?

Kinda trying to figure out my BKM I guess.

P.S. Or maybe any other tips and tricks on how to go through a list of experiments?

Re: How to highlight cell if previous row is different (kinda conditional formatting in Excel)

txnelson — Sat, 21 Oct 2023 01:22:48 GMT

There are a few different ways that you can do this.

Use Select Duplicate Rows
1. Select the target column you want to see the change in
2. Click on the red triangle located at the top of the Row Stat(Row Number) column, and select
  1. Row Selection=>Select Duplicate Rows
  2. 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
    1. Go back to the red triangle and select
    2. Row Selection=>Invert Row Selection

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"

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() )
	)
);

I am sure there are other methods

Re: How to highlight cell if previous row is different (kinda conditional formatting in Excel)

miguello — Tue, 24 Oct 2023 22:44:59 GMT

Jim,

The last solution is exactly what I need. For some reason I didn't realize you can color single cell, not the whole row using the same command :)