Hello all,
Have been stuck on a situation that I am not sure is even possible, hoping for help. So I have a report made which shows the top 20 reps who have collected the most money daily as well as monthly. Now this report is a sub-report in a form. The form has a 30 second timer which will update all the data when equal to 0. Then the timer will restart back to 30. So basically its "live" data (every 30 seconds). I was wondering if it is possible to show some sort of color or image for the people that "pass" or "go up in rank". Assuming I would have to compare the data to the new data coming in some how. Maybe conditional formatting? Not sure if anyone has done this but help is very much appreciated.
Thank you