In a column of the Dow Averages or Daily Volume, how can conditional formatting be used to note a change in direction; i.e., a number higher - say green - or lower - say red, and also a third color to show a new high has been reached.  Then how to set these up to operate continuosly?  I can do some of this but not all, and am unable to drag settings so once set up no daily input is required.  Please help.

---

Reply from Richard Rost:

Unless you've got a separate cell indicating this change, you can't do this with simple conditional formatting. Once a value is updated, Excel has no idea what the old value in the cell is... without some VBA programming.