Conditional Formatting for columns

[MattMurdock]

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

[macropod]

Hi Matt,

See attached. I've used conditional formatting to apply one of three colours to the trigger cells - pale blue to for a value against a single trigger, yellow to indicate value against multiple triggers, red to indicate that a value should not be input against a given trigger (as there is already one for another portfolio).