Excel Help

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??
 
Back
Top