I usually have about 50 stocks that constantly update Last, High, and Low prices. I have conditional formatting on about 6 columns. No problems at all.
As for logging the high of the day, every trading platform DDE link that I've come across so far has the ability to link in not only the last...