Solved Conditional Formatting in a Report (1 Viewer)

[JRMT]

Hi Sir's Please Help me im having trouble in condtional formatting I have a Report that has Job No, Date Received, Date Completed etc...
i want to highlight Red the Maximum Number on the Job No. and highlight also Red the Newest Date in Date Received. how can i highlight also the Vehicle, Reg No, Works Required, Type and Unit Name from the highest number Job No and Newest Date in Date Received?
Thank you!

 

[pbaldy]

One way would be to put a textbox in the report header with a DMax function returning the largest job number in the report's source. Then use Conditional Formatting to compare the job number to that textbox.