I have a column tracking sales for 30 sales reps and the values will change daily. As we enter in the sales I would like that column with the totals to change background color for cell based on first, second and third highest totals. I have worked with conditional formatted before and found how to do this in Excel 2003 but we have 2010 now and the conditional formatting is totally different and I can't figure out how to do it in this version.
Can someone walk me through doing this please?
Bookmarks