I have a spreadsheet that keeps track of my golf scores and statistics. The courses that I have played are included in an Excel table (Course Table). This table is used as the source for a Data Validation list when entering my weekly golf results in another area of the spreadsheet. I want the golf courses entered as part of my weekly results to be color coded therefore I use conditional formatting to compare the course entered in the weekly results area to the courses in the Course Table to change the fill color. The conditional formatting works fine until I sort the Course Table. When I play a new course I add it to the Course Table and sort the table alphabetically to make finding the course in the data validation drop down box easier. Unfortunately when I sort this table it changes the colors of the courses entered in the weekly results. I’ve tried every combination of absolute and relative references in the conditional formatting equations with no success.
I have attached a simplified version of my spreadsheet for review. The current conditional formatting equation for one of the courses is:
=I5=$C$5
where I5 is the golf course in the weekly results and $C$5 is the golf course in the Course Table. Any help would be appreciated!
Thanks,
Rick
Bookmarks