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

Attached Files

Testbook.xlsx (12.6 KB, 17 views)