I tried searching, but my Google-Fu appears to not be functioning today.
What I want to do is Conditionally Format the field to Bold if it matches the value from the prior row.
So I have Field.A, Field.B, etc and I plan to bold the whole row if Field.A (in this row) equals Field.A (from the prior row).
I know how to apply the conditional format across the row (ie, to each field), and I know StringCompare(String1, String2), but I don't know how to grab the prior row's field.
Whether there's a function to do it, or I need to store the value in a variable so I can compare before updating to the current row, yadda yadda it's all good, but I need tips on how to do that.
I would imagine this has been done before.
FYI: The user can't control sorting, so I don't have to worry about that aspect.
What I want to do is Conditionally Format the field to Bold if it matches the value from the prior row.
So I have Field.A, Field.B, etc and I plan to bold the whole row if Field.A (in this row) equals Field.A (from the prior row).
I know how to apply the conditional format across the row (ie, to each field), and I know StringCompare(String1, String2), but I don't know how to grab the prior row's field.
Whether there's a function to do it, or I need to store the value in a variable so I can compare before updating to the current row, yadda yadda it's all good, but I need tips on how to do that.
I would imagine this has been done before.
FYI: The user can't control sorting, so I don't have to worry about that aspect.