I had a question about excel that I was hoping someone could answer. Basically, lets say I have 3 columns set up for a set of stocks. I have a column for purchase price, current price and sell trigger. I want to be able to glance down my list of stocks and once the current price is entered, I would like the entire box to turn yellow (or any color) if the current price is below my sell trigger. Does anyone know how to set this up??
Should be able to do this with conditional formatting which is easier than VBA: http://www.contextures.com/xlCondFormat01.html