A simple bit of scripting and a little conditional formatting can do this.
Write this script:
Set Variable [$$RecordNumber ; Get ( RecordNumber ) ]
Use the OnRecordLoad script trigger (see layout setup...) to run this script.
Use this conditional format on every field where you want to see a fill color or text style change:
$$RecordNumber = Get ( RecordNumber )
And specify the desired color and/or style change.
You must have the fields physically present on the layout (not just added via the modify button). Thus, you may need to enter layout mode and add the fields to your layout first. You can also select all your fields and apply this formatting to them all as one group to ensure identical settings for all and to save time and effort.
Is there a way to get this so the field only highlights in table view, and not in Form view?
Add the condition:
... and Get ( LayoutViewState ) = 2
( $$RecordNumber = Get ( RecordNumber ) ) and ( Get(LayoutViewState) > 0 )
Get ( LayoutViewState ) returns 0 for form view, 1 for list view and 2 for table view. Thus, this expression will not apply any formatting if the layout is in Form view, but will in table and list views.
Ah perfect thanks much!