MattMurdock
New member
- Joined
- Jul 18, 2012
- Messages
- 8
- Reaction score
- 0
- Points
- 0
Hi guys- I'll try my best to describe but hopefully you will better understand once you take a look at the sample workbook. Basically there are three different tables in a worksheet, with months being the column headings. The three different tables are portfolios, and the rows are the triggers (prices) where you would buy a certain volume.
My problem is that I want when the user enters a amount for Trigger 1- it will display an XXXX (or maybe highlight the cells) for Trigger 1 in the other portfolios. Trigger 1 will not always be in Portfolio A.
Is there a way to do this without insertting a formula into every cell for each month, maybe some conditional formatting or macro that I'm not aware of?
Thanks for any help
Matt
My problem is that I want when the user enters a amount for Trigger 1- it will display an XXXX (or maybe highlight the cells) for Trigger 1 in the other portfolios. Trigger 1 will not always be in Portfolio A.
Is there a way to do this without insertting a formula into every cell for each month, maybe some conditional formatting or macro that I'm not aware of?
Thanks for any help
Matt