I have created a form with a macro to sort a list into a given order preferance. There is also a checkbox function that highlights a group of cells in a row based on true/false checks. When i sort - the check boxes move but conditional formatting does not. Thus you could check b3 and it highlights columns in row 6 rather than row 3 based on the reorder. How can i make them all follow each other?
Help please!
Help please!