I am trying to make a series of color coded columns.  For example, the column would be green if MACD crossed up within the last three periods, red if MACD crossed down in last three periods and yellow otherwise.  I can handle the colors with the properties. But how to make an indicator that is +1 under one condition, -1 under another, and zero otherwise.  Any help would be appreciated.

One possible way to do so might be the following.

SGN(CountTrue(XUP(MACD, 0), 3) - CountTrue(XDOWN(MACD,0), 3))

Very clever. Thanks. 

I am assuming that I could do something similer with any indicator that has a function or Indicateor Formula Template but I would need to use a condition and two columns for things like PSAR or Ergodic.

Is that correct?  If not correct how would I do something similer for PSAR or the Ergodic indicater? Currently I am using conditions and one column for up and one column for down crossings.

You are correct that if you can make a formula for it, you can probably get three colors out of it.

If not, then you would probably need multiple WatchList Columns.

Note, that while PSAR is definitely problematic, some Ergodic indicators might not be.