I am in the process of applying conditional formatting to a list of names in an Access form so that - when their name is selected - it highlights the cell in a particular color. I currently have 60 names, but conditional formatting only allows for 50 different rules for one cell.
Is there a way to increase the number of conditional formatting rules allowed for a single cell in a Access form?