×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

conditional format of row data value

conditional format of row data value

conditional format of row data value

(OP)
I am using CR 2016

How can I make a field at record level change font colour if its value has changed from previous row value( in detail level) I should also say its ONLY the change in a detail row with any groupings I have

eg
y
1
1
1
1
2 - to show red fornt
2
x
1
1


ie row value - last row value (within group) not equal zero then highlighlight

RE: conditional format of row data value

You could set up a formula in the field Format Editor (Font tab). Something like: if previous({someField}) <> {someField}) the crred else crblack.

RE: conditional format of row data value

(OP)
This doesn't quite work Im afraid It works across the rows within groups but as per my example above showing group y and group x I don't want it to do this across all rows just within the rows within each group

RE: conditional format of row data value

The other way is to set up formulas to capture the 'previous' value and then compare it to the current value, resetting on the group level.

Thus at the Group Header (GH)

Shared numbervar somevar := {fieldvalue};

At the detail level in the font tab for the field

Shared numbervar somevar;
if somevar <> {fieldvalue} then crRed else crBlack

Code not tested, but pretty sure it will work.

RE: conditional format of row data value

(OP)
sorry but that didnt work either in fact it was worse!

RE: conditional format of row data value

Use Excel instead.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: conditional format of row data value

If not onfirstrecord and
{table.field}<>previous({table.field}) and
{table.groupfield}=previous({table.groupfield}) then
CrRed else
CrNocolor

-LB

RE: conditional format of row data value

(OP)
Hi LB, you seem to know what to do but was bit confused on what you want me to do and where. Sorry to be a pain but could you elaborate

Thanks

PS - SVought - er Excel is NOT an option or auditable! :)

RE: conditional format of row data value

Use this formula in the format field->font color->x+2 formula area.

-LB

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close