![]() |
Using Find in VBA based on font color
I've looked through a bunch of posts but am having problems finding
what I'm tyring to do...I have 2 spreadsheets. The one spreadsheet (called weights) has a list of all the strategies (7 in total) in blue font, and underneath has the underlying funds in black font, so for example, it says Convertible Arb (in blue) Fund A Fund B Fund C Equity LS (In blue) Fund D Fund E Fund F Fund G Fund H etc on the other spreadsheet (called rets), I have all the fund names (Fund A, Fund B, etc). I want to be able to do a lookup on the rets sheet which will return the strategy that the fund belongs to, so basically I need to say find this fund, look above it to teh first cell you find that has blue font. Does anyone know an easy way to do this? Thanks for the help! |
All times are GMT +1. The time now is 09:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com