Can someone please help. I have a simple report that pulls in Revision numbers. I simply want the conditional formatting in Access to only highligt the greatest (or highest) revision number. So the report would show Rev = 1, Rev = 2 and so on. In that instance only revision 2 should be highlighted b/c it has the highest value. I would like the report to continue to use that logic moving forward and higher and higher revision numbers are added. Any ideas? I tried and few things and nothing seems to work.