Not sure if this is conditional formatting or something else.
I have a set of data with 4 columns and over 1500 rows. Cols B to D are locked and the sheet is protected. This is a membership list where col A contains the members surname and col C contains their membership number. If the user selects say A15 I want to highlight C15 so that they can easily see the membership number. Often the user will use search to locate the surname, and if multiple occurrences of the same surname they will just use the mouse or down arrow to select the correct row. It is basically just a lookup sheet for the user, the data in it is all derived from other worksheets.
Any suggestions?
Bookmarks