Highlight the greatest value as new values are added

[Triland]

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.

[alansidman]

Have you looked at conditional formatting.

http://www.techonthenet.com/access/f...format2007.php

[Triland]

I looked at conditional formatting but am having a problem actually just getting the highest value to be highlighted. I can get it to highlight a value. I just don't know how to get it to highlight the greatest value. I'm thinking it might be an expression in conditional formatting, but I just don't know.

[June7]

Duplicate topic https://www.accessforums.net/access/...ess-31489.html

Triland, please be patient. It is bad forum etiquette to create multiple threads on same topic.

I was going to work with your database when I got home but you already deleted the file. I did download at work but forgot to bring home. Now will have to wait till tomorrow.