I have a list made up for a group of people that gain points every week. I have the total points for each person in a column and have set conditional formatting to highlight 3rd place a color, 2nd place a color and 1st place a color. The problem is is that it worked perfect when I set it up, I saved and then closed it. Now when I opened it back up the conditional formatting is not working, it highlights all as 1st place. When I email it to someone it works fine for them. Im using Excel 2016 if that matters. Any ideas would be great. Thanks.
Bookmarks