leleuxc2000
New Member
- Joined
- Aug 31, 2011
- Messages
- 6
I have a table in a spreadsheet (9 columns) that contains information about individuals - it will have hundreds of records in it.
I have a combo box that will select the individuals names. What I'd like to be able to do is highlight the corresponding rows once they're selected - and leave them highlighted. I've tried multiple approaches to this and can't seem to make it work.
The closest I've come is with conditional formatting - this will highlight the row I've selected, but it changes when I select another value from the combo box.
The idea I have is once I select a value from the combo box, update a cell in a new column in the table with a "Y", and then apply conditional formatting using that column, but I can't figure out how to make that work.
Can someone help me figure this out? I'm not very experienced with VBA coding in Excel - but can probably make that work if someone can help me out.
Thanks in advance.
I have a combo box that will select the individuals names. What I'd like to be able to do is highlight the corresponding rows once they're selected - and leave them highlighted. I've tried multiple approaches to this and can't seem to make it work.
The closest I've come is with conditional formatting - this will highlight the row I've selected, but it changes when I select another value from the combo box.
The idea I have is once I select a value from the combo box, update a cell in a new column in the table with a "Y", and then apply conditional formatting using that column, but I can't figure out how to make that work.
Can someone help me figure this out? I'm not very experienced with VBA coding in Excel - but can probably make that work if someone can help me out.
Thanks in advance.