Lookup value in "previous" /conditional format
I am trying to conditionally format a number of fields based on whether their value changes from the "previous" record or not. If the field value is equal to the value in the record before it it must display differently than when it changes.
Record order would be based on a "Record#" field. I'm not sure if it matters but Record# unfortunately cannot be serialized as the record#'s will sometimes change or move around. Record#'s are also not always sequential (skip numbers) and sometimesa are whole integers, sometimes decimals.
One part of what I'm trying to accomlish can be illustrated with the screen shot below. When a value stays consistant it is purple, when it changes it is a different color.