I have a report which serves as a manufacturing worksheet in our factory and it shows the cutting sizes for pieces of material.
Our cutters keep making a mistake when there is multiple cuts at one size (e.g 1500mm) and then one at another size (e.g. 1800mm). For some reason they get in a groove and accidentally cut the 1800 at 1500.
To make it more obvious I want to make a conditional format that makes the 1800mm Bold if the two previous records are the same.
Anyone got any idea what expression I could use to say -
If currentrecord - 1 = currentrecord - 2 but <> currentrecord