Excel Help

Discussion in 'Trading Software' started by cc10, Dec 2, 2007.

  1. cc10

    cc10

    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??
     
  2. et123

    et123

    can easily be done via VBA - set cell color property to colors you want when conditions are met.