LinkBack URL
About LinkBacks
Hi
I have used hlookup,index and match formula to bring back data which is close to "todays date" but i how do i bring back the cell colour as well? please see attachment?
Hi
I have used hlookup,index and match formula to bring back data which is close to "todays date" but i how do i bring back the cell colour as well? please see attachment?
Last edited by fezn; 10-13-2013 at 04:55 PM.
Please Login or Register to view this content.
Open up the VBA editor by hitting ALT F11
Paste the macro into the Sheet1
Hit ALT F11 to get back to the worksheet.
Martin
Hi and welcome to the forum
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the adress bar)
To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi.
Thanks for that, I have changed the post title now.
Hi Martin
Thanks for that, it worked!
Hi Martin
If i move the data on to row 5, the macro doesnt work, what do I need to change in the macro so that it works in different cells?
Thanks
Thanks for the title change, and seeing as you still have a question on this, I will mark the thread UNSOLVED for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks