CantExcel123
New Member
- Joined
- Mar 28, 2024
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
I've been messing around with this for a couple days and cant figure it out. Please help.
I have a spreadsheet where I have a dropdown list (data validation) that (on sheet1) references a list of names on sheet2. I would like to keep the source formatting (i.e. yellow fill, or red text, etc) from the list of names on sheet2 when I select a name on sheet1. I've tried a couple flavors of VBA that weren't exactly my setup, mor complicated if anything, (by changing the range of cells, etc) with no luck.
Please help.
I have a spreadsheet where I have a dropdown list (data validation) that (on sheet1) references a list of names on sheet2. I would like to keep the source formatting (i.e. yellow fill, or red text, etc) from the list of names on sheet2 when I select a name on sheet1. I've tried a couple flavors of VBA that weren't exactly my setup, mor complicated if anything, (by changing the range of cells, etc) with no luck.
Please help.
